May 23, 2012 at 11:25 am
I have run into an issue where i am getting error:
Error: 17310 Severity: 20 State: 1.
Which cause SQL Server to reboot 4 times during a backup procedure. What I have read this is a bug: http://connect.microsoft.com/SQLServer/feedback/details/511751/sql-server-2008-error-17310-severity-20-state-1-crash-and-restart
This appears to be a command issued by a thrid party tool for backups. So I looked at the machine (I Inherited) and found that the only 2 databases running on this machine meet the above bug master and model.
model2003-04-08 09:13:36.390100
master2003-04-08 09:13:36.390100
The files in the binn folder have a date of 2010-04-02
The question I have if I rebuild the master and model does it actually replace the dbs?
I am assuming based on the dates that the original dba or who ever restore these dbs from a 2000 version sql server, and I do not know why.
If I have missed something else let me know your input.
I'm hoping to avoid rebuilding entire windows server.
Server info
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
May 23, 2012 at 11:37 am
Possibilities that come to mind are a misdone in-place upgrade, or someone really badly messed up and restored the wrong backup of those. I'm not even sure that's possible, but it's plausable, and I don't have a server I can try it on right now. (My proof of concept server is being used for a different kind of test at the moment.)
I'd try rebuilding them. It seems like the simplest place to start.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 23, 2012 at 12:03 pm
Yes, that was my thoughts, only worry is that it will screw the whole thing up.
May 23, 2012 at 12:43 pm
bopeavy (5/23/2012)
I have run into an issue where i am getting error:Error: 17310 Severity: 20 State: 1.
Which cause SQL Server to reboot 4 times during a backup procedure. What I have read this is a bug: http://connect.microsoft.com/SQLServer/feedback/details/511751/sql-server-2008-error-17310-severity-20-state-1-crash-and-restart
This appears to be a command issued by a thrid party tool for backups. So I looked at the machine (I Inherited) and found that the only 2 databases running on this machine meet the above bug master and model.
model2003-04-08 09:13:36.390100
master2003-04-08 09:13:36.390100
The files in the binn folder have a date of 2010-04-02
The question I have if I rebuild the master and model does it actually replace the dbs?
I am assuming based on the dates that the original dba or who ever restore these dbs from a 2000 version sql server, and I do not know why.
If I have missed something else let me know your input.
I'm hoping to avoid rebuilding entire windows server.
Server info
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
running a rebuild will replace them, if you're lucky you may be able to restore the master and msdb as user databases and script out the objects you need 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2012 at 4:07 pm
SQL itself won't allow you to restore an older master db (not sure about the model db, but it likely doesn't contain critical data anyway). Something else must be going on.
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".
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply