sql 2000 restore fails
I'm trying to restore a sql 2000 db from a backup but it is failing saying the log file is not available. I have also tried using sp_attach_single_file_db but this also fails. I don't know how the db was backed up and i also can't use restore no_recovery. I have a backup file and the original mdf file.
Last Comment
ASKER
yes the account is a local admin
haven't tried the with move option
yes the location is online
no it's a cluster thats jus come back online.
haven't tried the with move option
yes the location is online
no it's a cluster thats jus come back online.
ASKER
yes the account is a local admin
haven't tried the with move option
yes the location is online
no it's a cluster thats jus come back online.
haven't tried the with move option
yes the location is online
no it's a cluster thats jus come back online.
With these commands you can find what is in the backup. http://msdn.microsoft.com/en-us/library/ms190372.aspx
In management studio you can create a database by only attaching the mdf^-file. It wil ask to create a log-file.
>>I'm trying to restore a sql 2000 db from a backup but it is failing saying the log file is not available. <<
Why are you not doing a RESTORE from a SQL BACKUP?
Why are you not doing a RESTORE from a SQL BACKUP?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
i've just tried restoring it on an 2k5 box and it has found an error on a page. The 2k server was in a cluster and we lost the shared storage so i'm trying to repair it using one of those 3rd party tools now.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
A few questions if you please don't mind:
Does the SQL Server service account have rights to the folders where you are attempting to put the log and data files?
Have you tried restoring using the WITH MOVE clause to put the files in different location?
Have you verified that the location exists and is online?
Is this a newly rebuilt server with all the same volumes the source server had?
Thanks!
Dan