January 26, 2009 at 11:22 pm
Hi m getting an error while restoring the backup ... restoration is getting successfully complted ... still there is an error ..
Restore,Step1,,Executed as user: NT AUTHORITY\SYSTEM. ...e 3211) 20 percent processed. [SQLSTATE 01000] (Message 3211) 30 percent processed. [SQLSTATE 01000] (Message 3211) 40 percent processed. [SQLSTATE 01000] (Message 3211) 50 percent processed. [SQLSTATE 01000] (Message 3211) 60 percent processed. [SQLSTATE 01000] (Message 3211) 70 percent processed. [SQLSTATE 01000] (Message 3211) 80 percent processed. [SQLSTATE 01000] (Message 3211) 90 percent processed. [SQLSTATE 01000] (Message 3211) 100 percent processed. [SQLSTATE 01000] (Message 3211) Processed 2449192 pages for database 'databse1' file log' on file 1. [SQLSTATE 01000] (Message 4035) RESTORE DATABASE successfully processed 2449200 pages in 783.266 seconds (25.615 MB/sec). [SQLSTATE 01000] (Message 3014) Could not locate file 'databse1_log' for database 'master'. [SQLSTATE 42000] (Error 8985).
January 26, 2009 at 11:29 pm
It looks like logfile is not able to locate the file database_log1. use sp_helpdb master. check to see if the files are present.
Note: take the full backup for master database before restoring it.
January 27, 2009 at 12:31 am
no issue with that...
February 1, 2009 at 9:11 pm
as my job is running for the restoring database m still getting this error....
February 1, 2009 at 9:13 pm
as my job is running for the restoring database m still getting this error.... there are 2 databases which are restored by the same database backup....
February 1, 2009 at 11:39 pm
What DB are you restoring?
Can you post the code that you're using to do the restore?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 4:28 am
in error it is showing that 1 logfile is missing for master database.
You need to check startup parameter in sql server configurationmanager
rightclick on SQL server service >> Properties >> advanced.
there in startup parameter check with name of log file for master.
generally it is mastlog.ldf
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply