January 11, 2011 at 4:04 am
Hi, I'm looking after a SQL server 2000 at work, recently we was told we're going over to a new SQL 2008 server, what I'm after doing is backing up all the data from the 2000 machine to be used by the 2008 box until we're ready to switch the 2000 box off, I'd like to be able to automatically copy the data between the boxes each night, is there an easy way to do this, if so, how?
January 11, 2011 at 4:10 am
mick burden (1/11/2011)
I'd like to be able to automatically copy the data between the boxes each night, is there an easy way to do this, if so, how?
Maybe you should take a look at either log shipping or replication. Alternatively you can create a job on the 2000 box that creates the backup and copies it to the 2008 box every night and then create a job on the 2008 box that restores it every morning.
Best regards
Lars Søe Mikkelsen
January 11, 2011 at 4:12 am
Thanks for the reply Lars, not sure how to do either of those suggestions
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply