<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Older Versions of SQL (v6.5, v6.0, v4.2)
»
Older Versions of SQL (v6.5, v6.0, v4.2)
»
Need to help to Restore/attach a database in...
11 posts, Page 1 of 2
1
2
»»
Need to help to Restore/attach a database in SQL 6.5
Rate Topic
Display Mode
Topic Options
Author
Message
pelsebubb
pelsebubb
Posted Tuesday, October 23, 2012 1:44 AM
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 3:32 AM
Points: 20,
Visits: 48
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
prettsons
prettsons
Posted Tuesday, October 23, 2012 4:18 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 2:27 AM
Points: 100,
Visits: 1,090
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
pelsebubb
pelsebubb
Posted Tuesday, October 23, 2012 6:05 AM
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 3:32 AM
Points: 20,
Visits: 48
Im using trusted connection with sa user, i also verified that that SP is not in the master db.
Post #1375992
David Webb-CDS
David Webb-CDS
Posted Tuesday, October 23, 2012 9:17 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 4:48 PM
Points: 834,
Visits: 5,836
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
SQLRNNR
SQLRNNR
Posted Tuesday, October 23, 2012 9:35 AM
SSCoach
Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853,
Visits: 12,438
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 2008
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
pelsebubb
pelsebubb
Posted Tuesday, October 23, 2012 9:40 AM
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 3:32 AM
Points: 20,
Visits: 48
i actually tested that tool also, it worked.. only tool i got to work
Post #1376144
pelsebubb
pelsebubb
Posted Tuesday, October 23, 2012 9:41 AM
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 3:32 AM
Points: 20,
Visits: 48
i will try the new db restart sequense
Post #1376145
pelsebubb
pelsebubb
Posted Tuesday, October 23, 2012 11:42 AM
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 3:32 AM
Points: 20,
Visits: 48
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
prettsons
prettsons
Posted Friday, October 26, 2012 3:13 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 2:27 AM
Points: 100,
Visits: 1,090
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
David Webb-CDS
David Webb-CDS
Posted Friday, October 26, 2012 9:31 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 4:48 PM
Points: 834,
Visits: 5,836
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 »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
