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
Author
Message
Posted Friday, October 26, 2012 9:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:34 AM
Points: 430, Visits: 977
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:

RESTORE DATABASE <newDB>
FROM DISK="<backup file path>"
WITH REPLACE




Post #1614434
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse