Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Jun 30 '11 at 10:00

This question came from our site for professional and enthusiast programmers.

2 Answers 2

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

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

Your Answer

 
discard

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