I have a Database of 50Gb of data on Test Server A, I want to take the Backup and I want to Restore it to Test Server B. I need Backup and Restore step by step with query's?
migrated from stackoverflow.com Jun 30 '11 at 10:00
This question came from our site for professional and enthusiast programmers.
If you are unsure, start with these MSDN how-tos
You'll need to copy the backup file from serverA to serverB of course.
SSMS will allow you to script these actions too so you can see teh underlying SQL commands
use mysqldump if you are using MySql db http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html