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 ««12

Need to help to Restore/attach a database in SQL 6.5 Expand / Collapse
Posted Friday, October 26, 2012 9:56 AM


Group: General Forum Members
Last Login: Wednesday, September 18, 2013 5:27 AM
Points: 23, Visits: 56
David Webb-200187 (10/26/2012)
Were these files copied from a SQL Server that was running when the files were copied? If so, they may not be in a state that will allow them to be attached. That may be why the database went suspect when you did the copy-and-restart sequence.

Is there any way you can get a backup of this database rather than trying to use the raw files?

Okey. Only got those files i managed to export all to SQL format with the program i bought.
Post #1377707
Posted Wednesday, September 17, 2014 7:29 AM


Group: General Forum Members
Last Login: Tuesday, November 24, 2015 4:58 AM
Points: 484, Visits: 1,159
If memory serves -- and it's been a loooong time -- the detach-attach functionality only arrived with SQL 7.
So you're stuck with Restore Database.
First, create an new, empty db.

I think this is the 6.5 syntax:

FROM DISK="<backup file path>"

Post #1614434
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse