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 Tuesday, October 23, 2012 1:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 5:27 AM
Points: 23, Visits: 56
I have the data.Dat and log.dat files, but i find it hard to actually attach it or restore it into sql 6.5.

Tried with Stored procedure 'sp_attach_db', but that is not found on the server.

Can anyone help me with the sql query to attach DB to this server version.
Post #1375881
Posted Tuesday, October 23, 2012 4:18 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 12:44 AM
Points: 102, Visits: 1,165
The account doing the attach needs full permissions on the database files. In addition, the service account needs full permissions on the files.

SQL Database Recovery Expert
Post #1375943
Posted Tuesday, October 23, 2012 6:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 5:27 AM
Points: 23, Visits: 56
Im using trusted connection with sa user, i also verified that that SP is not in the master db.
Post #1375992
Posted Tuesday, October 23, 2012 9:17 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:29 AM
Points: 893, Visits: 6,900
Is this actually a SQL Server 6.5 database? If it is, you might try creating a database with the same file names, shutting down the server, replacing the created files with your existing files and re-starting the server. Make copies of the files before you do this, just in case.



And then again, I might be wrong ...
David Webb
Post #1376133
Posted Tuesday, October 23, 2012 9:35 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:38 PM
Points: 20,485, Visits: 14,142
Here is a tool that others have had work

http://www.officerecovery.com/mssql/




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1376143
Posted Tuesday, October 23, 2012 9:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 5:27 AM
Points: 23, Visits: 56
i actually tested that tool also, it worked.. only tool i got to work
Post #1376144
Posted Tuesday, October 23, 2012 9:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 5:27 AM
Points: 23, Visits: 56
i will try the new db restart sequense
Post #1376145
Posted Tuesday, October 23, 2012 11:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 5:27 AM
Points: 23, Visits: 56
pelsebubb (10/23/2012)
i will try the new db restart sequense


Tried this with no success, the DB popped up in suspect mode, and i could not reset it with emergency mode, guess i have to buy that damn software then.
Post #1376185
Posted Friday, October 26, 2012 3:13 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 12:44 AM
Points: 102, Visits: 1,165
In any case, restoring from a backup is the best way to resolve this issue. Or you should try third party SQL repair software as SQLRNNR already suggested. Take a look 'Stellar Phoenix SQL Recovery' Software!!

SQL Database Recovery Expert
Post #1377442
Posted Friday, October 26, 2012 9:31 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:29 AM
Points: 893, Visits: 6,900
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?




And then again, I might be wrong ...
David Webb
Post #1377681
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse