How do I backup and restore a database using sql script?

Question

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?

score 1 · Answer 1 · answered Jun 30 '11 at 09:05

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

score 0 · Answer 2 · answered Jun 30 '11 at 08:36

0

use mysqldump if you are using MySql db http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

for export

mysqldump --opt --user=root --password test dbname > dbbackupscript.sql

for import

mysqldump --opt --user=root --password test dbname < dbbackupscript.sql

answered Jun 30 '11 at 08:36

Question was tagged sql-server – Jun 30 '11 at 08:39
Tell me as A SQL DBA how to do? – Jun 30 '11 at 08:50
am a BEGINNER of SQL SERVER DBA. So I need a step by step procedure to take backup and restore process on Test Server. – Jun 30 '11 at 08:56

How do I backup and restore a database using sql script?

2 Answers2