July 15, 2009 at 3:41 am
how to take backup of a database from one server to another or how to movethe backup files from one server to another ?
thanks
July 15, 2009 at 3:48 am
ramyours2003 (7/15/2009)
how to take backup of a database from one server to another ?
use network share.
or how to movethe backup files from one server to another
copy/paste.
July 15, 2009 at 4:24 am
We used to have a XCOPY command in a .bat file and is called by a windows scheduler task every night.If you want to schedule it then use this method.
July 15, 2009 at 6:53 am
A backup of a database is just a file, so you can move it any way you want. Copy & paste, as mentioned before will work. XCopy will work. If you want to drag & drop within Explorer... whatever, you can move the backup around to other media, network shares, thumb drives, external drives, whatever. You just have to have access to that location from the second server in order to run the RESTORE command.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply