Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restoring a SQL Server 6.5 Database dump Expand / Collapse
Author
Message
Posted Thursday, November 13, 2008 2:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:33 AM
Points: 27, Visits: 128
I am trying to restore a SQL Server 6.5 database dump from one SQL server instance to another. I am unable to perform this task through the GUI...

Does any one know where I can find a script to restore my database?
There aren't too many documentation to help me since this version of SQL Server is a little old...

Thanks...
Post #602392
Posted Friday, November 14, 2008 4:56 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 8:00 AM
Points: 5,888, Visits: 13,064
its been a long time and I don't have a script, but your problem might be that before being able to restore you need to ensure the device layout the database sits on in the new instance is identical to the layout where the database came from.

After that the restore command is basically the same as it is now except you will be restoring from a device rather than a file, but the gui should handle that for you.

post any error you are getting, you might get a few more responses.


---------------------------------------------------------------------

Post #602633
Posted Friday, November 14, 2008 5:10 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 7, 2011 1:41 AM
Points: 346, Visits: 534
smatu (11/13/2008)
I am trying to restore a SQL Server 6.5 database dump from one SQL server instance to another. I am unable to perform this task through the GUI...

Does any one know where I can find a script to restore my database?
There aren't too many documentation to help me since this version of SQL Server is a little old...

Thanks...


what version of SQL server you want to restore in. and what error you are getting


kshitij kumar
kshitij@krayknot.com
www.krayknot.com
Post #602634
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse