sp_attach_single_file_db - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sp_attach_single_file_db

Author

Topic

zoldor_x3
Starting Member

1 Post

Posted - 2008-09-29 : 23:21:20

I was having problems with my server and my DB was not cleanly shut down. I do not make backup and i don't have log file ... Now i try to restore my data base employed this procedure

USE master;
GO
EXEC sp_attach_single_file_db @dbname = 'RCMeasurements',
@physname = N'D:\SQL\DATA\RCMeasurements_Data.MDF';

but i catch a message:
File activation failure. The physical file name "D:\SQL\Data\RCMeasurements_Log.LDF" may be incorrect.
The log cannot be rebuilt because the database was not cleanly shut down.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'RCMeasurements'. CREATE DATABASE is aborted.

Please give me advice, what can i do?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-29 : 23:27:04

Thats why it is important to have backup in place.
see this:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=630182&SiteID=1

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources