September 23, 2003 at 9:12 am
I am running MSSQL 6.5 and need to export/backup a database to a file and then take that file and import/restore on a system that is not on my LAN (Dev platform) which is also running MSSQL 6.5
Is there an easy way to do this. It seems that backup to a .DAT file and then attmepting restore on the different machine does not work well.
Kevin-
Thanks For your continued Help.
Thanks For your continued Help.
September 23, 2003 at 10:31 am
That is the easiest way. What doesn't work with this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 1:16 pm
If that doesn't work make sure that the 2 servers have the same sort order. That is the only reason I can remember for ever having a problem restoring a sql backup on 6.5.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 1, 2003 at 3:37 pm
Just a thought...
You are initializing the devices, and creating the database before trying to restore, right???
Steve Phelps
SQL Server DBA
American Fidelity Group
October 1, 2003 at 7:21 pm
Not only sort order, but also you have to initiate and allocate database device spaces and fragments exactly same as the devices in your original server. The device fragments that the new database uses for data and for the log must appear in the same order and have the same amount of space as the fragments in the original database.
Use sp_help_revdatabase to generate CREATE & ALTER DB statements.The output statements are in the sequence necessary to facilitate
the LOADing of a DUMP DATABASE output file onto a new database.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply