March 23, 2009 at 12:39 pm
Hello,
I have to replace a sql server. The method would be:
1. backup sql2000 database on server1
2. copy the backup file to server2
3. restore the backup file into sql2005 on server 2
I have limited time to do this and want to know if this is possible at all:
1. Backup a sql2000 database on server1 directly into a sql2005 database on server2.
This would combine the three steps into one single step
thanks
March 23, 2009 at 1:34 pm
No.
March 23, 2009 at 7:07 pm
OCS (3/23/2009)
1. Backup a sql2000 database on server1 directly into a sql2005 database on server2.
Sorry, what did you mean by this?
March 24, 2009 at 7:51 am
I have the similar situation where:
1- I backup DB from server A to server B (choose location as \\servername\directory$\backup folder\file path.bak)
2- On server B, I restore the Database from the \\directory\backup folder\file path.bak
3- A job on server B that cleans up the backup a couple of hours after restore has finished.
March 24, 2009 at 1:23 pm
Is there a way you can create a .bak on a different computer/server?
I thought you could only create them on the local machine. If it's possible, please explain how.
If you go to Tasks-->Backup... and then choose your location, it only shows local drives.
I am currently looking for a way to create backups and then have them shipped to a different computer all in one job. Any ideas?
March 24, 2009 at 1:35 pm
This article will answer all your questions:
http://www.mssqltips.com/tip.asp?tip=1126
Gethyn Elliswww.gethynellis.com
March 24, 2009 at 2:13 pm
Worked Beeeaaaauuuuutifully.
Thanks.
The admin privilege got me for a second but it works great now.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply