unable to get the database online using the method

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jonathan Kehayias » unable to get the database online using the...

unable to get the database online using the method

Rate Topic

Display Mode

Topic Options

Author

Message

nikithanaidu

Posted Wednesday, August 26, 2009 12:52 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 3:59 PM
Points: 4, Visits: 543

Jonathan,
after executing the alter database modify file command and putting back the database to offline.
and moving the physical files over to the new path. and when i try to set the database back to online, i get this error.

File activation failure. The physical file name "D:\MSSQLTEST\iww_statistics_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 1
Database 'iww_statistics' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

Post #777769

« Prev Topic | Next Topic »

Permissions