The SQL server log file giving error. How can be repairing ms sql log files ?
I was redoing a log file operation in database. The error occurred at log record ID (9767813:109:10). I have following problem:
Command:
EXEC sp_attach_single_file_db @dbname = \'world\',
@physname = \'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\world.mdf\'
The error message is:
Msg 1813, Level 16, State 2, Line 1
Could not open new database \'world\'. CREATE DATABASE is aborted.
Msg 3456, Level 21, State 1, Line 1
Could not redo log record (9767813:109:10), for transaction ID (1:1182802845), on page (1:27846), database \'world\' (database ID 5). Page: LSN = (9767810:70:66), type = 2. Log: OpCode = 3, context 19, PrevPageLSN: (9767812:47:11). Restore from a backup of the database, or repair the database.
Msg 3313, Level 21, State 2, Line 1
Any idea for repairing ms sql log files?
Know the Answer? Share it...
The SQL server log file giving error. How can be repairing ms sql log files ?
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 ?
