up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

migrated from stackoverflow.com Jun 30 '11 at 10:00

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

2 Answers

up vote 0 down vote

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
link|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
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard