Here is the situation, I have a web application (asp.net/vb.net) with ms sql 2000 as the database. I have two database server. I would like to backup database 1 with database 2. I would like to do it at intervals and through code. If anyone can give me some ideas on how to do this or any research material, please do.
ThanksAnd the copy the stript|||You will need to set up a linked server. You can then run:
EXEC SERVER.master.dbo.xp_executesql @.backup_command
No comments:
Post a Comment