June 16, 2009 at 1:09 pm
aplcaiton people done some chages .after that changes cpu is more utilised by sql server .so i restarted sql .performance is ok but one my db went suspect .now how can i return back that suspected db
error is:
could not open the device D:\programfiels\michrosoft sql server\mssql\data\tiger_data.mdf
event id:17055
type :error"
category:2
June 16, 2009 at 1:18 pm
Is the D drive still accessible?
Is the .mdf file where SQL expects it to be? (D:\programfiels\michrosoft sql server\mssql\data\tiger_data.mdf)
Does the SQL Server service account have full rights (read and write) to that file?
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
July 2, 2009 at 3:36 am
Gail is correct .......its not able to open the MDF file ..
Check the SQL Server error logs for the actual error and copy here ..
It could br due to OS error 3,5 etc ....
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply