Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from 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

for export

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

for import

mysqldump --opt --user=root --password test dbname < dbbackupscript.sql
share|improve this answer
Question was tagged sql-server – Tom Carter Jun 30 '11 at 8:39
Tell me as A SQL DBA how to do? – sriakanth Jun 30 '11 at 8: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. – sriakanth Jun 30 '11 at 8:56

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.