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.
use mysqldump if you are using MySql db http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
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