March 12, 2007 at 10:29 am
Hi all,
Windows 2000 SP4/ Sql server 2000 standard edition
I have two databases located in two different servers and I like to execute a copy from the first server to the second one. I tried to use export/import using DTS but doesn't work well.
Now I'd like to planify automatic backup/restore between the two databases (from source to target).
How can I do that ?
Thanks for any suggestions.
Hassan
March 14, 2007 at 9:14 am
Hi Hassan,
Could you explain a little about what you want to do with the second instance? It kind of sounds like you're describing log shipping when you talk about automatic backup/restore, but the target database being restored isn't available for use. Perhaps you just want to schedule full database backups and restores? Replication is another option for keeping the databases on different servers in sync.
What didn't work well with DTS? I have lots of scheduled packages that export/import data from one database to another.
Greg
Greg
March 14, 2007 at 9:24 am
How about
BACKUP DATABASE dbName TO DISK = '\\targetServer\$mapDrive'
You need to have authority to create a mapping drive in the above approach.
You can also create a database device first.
After backing up your database to your target server, you can use sp_addserver stored procedure to link the two servers, and trigger a database restore task.
Hopefull, it helps.
March 16, 2007 at 10:37 am
Don't forget to make sure the agent has rights to the share folders that you set up.
Marvin Dillard
Senior Consultant
Claraview Inc
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply