The error is generated in database. How to check db space mssql ?
I was working on a databse which is called as emergencydemo. I saw that there was no log file in EMERGENCY mode and the salaries table is corrupt. I am worried that how I will maintain the data. The error was:
ALTER DATABASE emergencydemo SET ONLINE;
GO
File activation failure. The physical file name \"C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\emergencydemo_log.LDF\" may be incorrect.
The log cannot be rebuilt because the database was not cleanly shut down.
Msg 945, Level 14, State 2, Line 1
Database \'emergencydemo\' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Failed to restart the current database. The current database is switched to master.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
After that when I expected that not to do work, the emergency mode repair run:
DBCC CHECKDB (emergencydemo, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
GO
Msg 945, Level 14, State 2, Line 1
Database \'emergencydemo\' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Now I am middle in the problem. What to do to check db space mssql.
Know the Answer? Share it...
The error is generated in database. How to check db space mssql ?
Related Question
Slow performance of SQL server 2005 ?
State a way with which I can get fixed my entire corrupt SQL Database? ?
Suggest a Recovery for repairing the Read only Database in SQL 2000 ?
Is Mdf Repair Software best for SQL Server files of 2005? ?
Suggest for a Database Repair Tool for SQL Server 2005 ?
Suggest a process for fixing a table in Ms Sql? ?
How can you recover the Index Fragmentation in the SQL Database? ?
State a recovery for the corrupt index Database of Ms Sql. ?
Make a recovery for MDF files which has got deleted unexpectedly. ?
You are not allowed to access the database from this machine, please verify your access id or contact database administrator”. What this message indicates? ?
Incorrect Key File for table”….Try to repair it.” What this message specifies? ?
Database got corrupt by SQL Injection Attacks”. How to Repair ?
I am middle in the problem. Facing error in I/O operation on sql. Give solution for best command to repair mssql database ?
The error is generated in database. How to check db space mssql ?
SQL database giving an error on 2000 sql repair tool is working slowly. What to do ?
Getting the errorin SQL 2005: # table corrupted # buffer is too small, unavailability of free disk space. ?
How to run dbcc on mdf file on MS SQL server 2005. Describe some solutions ?
The SQL server log file giving error. How can be repairing ms sql log files ?
my SQL table database does not return any value. How to restore table from mdf file ?
The MS SQL has generated an error while restoring the database. How to recover mssql database ?
SQL is giving an encrypted error. How to fix mdf file of sql server 2005 error ?
Table error: Object ID 0, index ID 0, page ID (1:105). The PageId in the page header = (0:0) ?
Bug in libmysql.dll ?
Destroyed key cache still usable ?
Problem with intensive locking (deadlocks?) during execution of system_1_test ?
Merge table with INDEX statements out of order returns NULL for index columns ?
Overflow must be an error ?
Table name in Error message not in default character set ?
Lost Data with delayed insert or mysqlhotcopy or lock and flush ?
