SQL Server Performance Forum – Threads Archive
backup and restore to another serverHi Folks,
I need to take back up of a database from server A and resotre the backup to serverB. How can this be done?
Please provide me proper steps to carry out this activity as it is a cluster environment.
How can a backup be copied from one server to another both in sql 2000/2005?
Just run the backup using QA OR EM on source serverA.
Backup database <dbname> to disk = ‘\servernamec$dbname.bak’
with init, stats = 10 Run the restore command using QA or EM on Destination ServerB. Restore database <dbname> from disk ‘\servernamec$dbname.bak’
with recovery, replace,
move ‘Datafile Logical filename’ to ‘Phisical filename and path’,
move ‘LogFile Logical filename’ to ‘Phisical filename and path’ Check BOL for complete syntax… You can restore the backup of sql 2000 on to sql 2005 and backup restore method is the same in 2000 and 2005 and there is no difference when you are running backup or restore on cluster…
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.