January 3, 2012 at 1:22 pm
Hi.... guys...
Event ID:3313
During redoing of a logged operation in database 'master', an error occurred at log record ID (362:72:5). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
Please help.....thnx
January 3, 2012 at 1:32 pm
Do you have a recent backup of the master database?
What does your windows event log say?
January 3, 2012 at 1:37 pm
No i did not have any recent backup and i only have mdf and ldf file
thnx.....
January 3, 2012 at 1:45 pm
How important is this instance of sql server?
January 3, 2012 at 1:49 pm
It is having Symantec backup front end and back end as SQL so i just wanted to start SQL Service any how ? and symantec backup will be running periodically but job is failing due to service stopped?
Reply ....
January 3, 2012 at 2:05 pm
Well, you could restart the database in single user mode and rebuild the master. But that puts you back to the default system configuration.
This means any logins, linked servers, system settings and configurations that are not default, will need to be recreated. You'll probably also need to reattach you user databases.
That doesn't solve the original problem though. There should be some errors in the windows event logs that'll give you a hint at the original problem.
January 3, 2012 at 2:20 pm
Unable to start the service after taking in single user mode also.
Tell me another option as this is not helping me?
Reply fast.........thnx
January 3, 2012 at 2:31 pm
First, make a copy of the existing master data file(s) and log file (in Windows, not a SQL BACKUP). You may be able to read some data out of these later.
Then use "rebuildm.exe" stand-alone to create a new master from scratch.
That should at least allow you to start SQL Server.
Then try to attach the existing master db files as a different db name, just to try to make that data readable in any way you can. If you can get the db attached, put it in "Emergency" mode or zap the status to make it readable.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
January 3, 2012 at 2:41 pm
ScottPletcher (1/3/2012)
First, make a copy of the existing master data file(s) and log file (in Windows, not a SQL BACKUP). You may be able to read some data out of these later.Then use "rebuildm.exe" stand-alone to create a new master from scratch.
That should at least allow you to start SQL Server.
Then try to attach the existing master db files as a different db name, just to try to make that data readable in any way you can. If you can get the db attached, put it in "Emergency" mode or zap the status to make it readable.
This sounds like good advice except the use rebuildm.exe which I don't believe exists in sql server 2008.
While you are backing up the files of the old master you should backup the files for the rest of the system databases, and probably the user databases.
January 3, 2012 at 2:49 pm
I have SQL Server 2005 Edition and how to resolve this issue please advice?
Reply thnx....
January 3, 2012 at 2:52 pm
Excellent point.
For SQL 2008, you must do run:
setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=instance_name
/SQLSYSADMINACCOUNTS= accounts [/SAPWD=password]
If in Mixed mode, specify the /SAPWD; if Windows/Authenticated only, leave it off.
Have to admit I haven't done this in forever (since SQL 2000). I take a copy of the physical .mdf and .ldf files periodically instead, so if I have to, I just copy those files into place to start SQL.
(Yes, SQL must be down to copy the physical files ... so when I do any maintenance that requires SQL to be down, I copy the physical files if it's been a while. This is only an emergency precaution, in case master is damaged so badly SQL won't start. As soon as SQL starts, I restore the latest backup of master, which is backed up at least daily.)
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
January 3, 2012 at 2:55 pm
SQL 2005 is different from either.
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx
1. Insert the SQL Server 2005 installation media into the disk drive.
2. Use the following syntax:
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
Important:
Do not use a blank password. Use a strong password.
For the default instance, specify "MSSQLSERVER" for <InstanceName>.
Important The resource database (mssqlsystemresource) is restored from SQL Server 2005 distribution media. When you rebuild the resource database from distribution media, all Service Packs and QFE updates are lost, and therefore must be reapplied. Before you proceed, see [REBUILDDATABASE] for more information.
The /qn switch suppresses all Setup dialog boxes and error messages. If the /qn switch is specified, all Setup messages, including error messages, are written to Setup log files. For more information about log files, see How to: View SQL Server 2005 Setup Log Files. The /qb switch allows display of basic Setup dialog boxes. Error messages are also displayed.
Rebuilding the master database installs all system databases to their initial location. If you have moved one or more system databases to a different location, you must move the databases again. For more information about moving system databases, see Moving System Databases.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
January 3, 2012 at 2:56 pm
That physical file copy thing's not looking so bad now, is it? :-):-)
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
January 3, 2012 at 2:57 pm
http://msdn.microsoft.com/en-us/library/ms144259(v=sql.90).aspx
-Edit Sorry for posting what you already did Scott.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply