Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

unable to get the database online using the method Expand / Collapse
Author
Message
Posted Wednesday, August 26, 2009 12:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 4:00 PM
Points: 4, Visits: 616
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 »

Add to briefcase

Permissions Expand / Collapse