April 29, 2013 at 7:50 am
sqlserver 2008 R2.
The error is:
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'FASTContent_CrawlStoreDB_2d3e9be9ef044393a736f16d569f0952'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Database 'FASTContent_CrawlStoreDB_2d3e9be9ef044393a736f16d569f0952' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
April 29, 2013 at 10:32 am
April 30, 2013 at 12:24 am
Thanks for your quick answer.
There is no space or memory issue. There are tons of GB. Also all the other mirroring of the other databases works.
There was problem of space in the logs directory, but the problem was handled.
May 1, 2013 at 8:00 am
What is the status of the mirror database, does it say mirror disconnected?
May 1, 2013 at 11:25 am
Check to see if the account which is trying to access the database has enough permission to access DB/ create mirror or Database autogrowth is on.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply