SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Versions of Disaster


Versions of Disaster

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)

Group: Administrators
Points: 106913 Visits: 19332
Comments posted to this topic are about the item Versions of Disaster

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
EdVassie
EdVassie
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9429 Visits: 3884
If you are talking about software versions, do not forget about the Windows patch level, the AV control file level, etc, etc ad almost infinitum. Then we get into hardware versions - it is actually possible to obtain a working 10-year old server that has the same hardware build as the environment we are supposed to reproduce.

My understanding is that the law does not mandate us to record the exact details of the software used on our servers on any given day. Legal process may ask us to show to the best of our ability how a particular piece of software worked at a given point in time, but it does not ask us to do the impossible.

If a reconstruction of a crime, etc, is done, effort is made to use clothing, actors, etc that match as closely as known to the actual event. But very seldom does the legal process care if the the weather is a bit warmer,colder, cloudier, etc than the actual event. The same precedents have to apply in computing.

A legal adversary may try to get penalties applied if the requested environment cannot be reproduced en every detail. It is the job of your own lawers to show that reasonable care has been taken in reproducing the environment, and it is as close to the original environment as it is reasonable to be. If the opponent is not asking for every detail (including the hardware) they seriously weaken their case that you are negligent in what you have been able to do. Any judge worth their office will accept that people cannot do the impossible. If you have complied with standard practice in your industry then you have a strong defense.

You just need to convince your own lawers about all of this...

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
george sibbald
george sibbald
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16990 Visits: 13695
Of course the version of SQL is recorded in the errorlog at startup, and in the event of an instance crash these logs will likely still be there.

Just in case as part of my DR processes I script out the server configuration, including the latest errorlog plus explicitly the SQL version using:

select convert(nvarchar(10),serverproperty('productlevel'))
select @@version

This is then offsited to another server and tape.

SQLdiag is a good little tool to run once in a while to give a good picture of the OS as well, but I do rely on the server admins to maintain doco on server builds.

---------------------------------------------------------------------
CraigYellick
CraigYellick
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 24
If you accept that disk space is very cheap relative to the cost and hassle of recreating your server environment, you can snap a copy as a virtual machine.

We run all our servers as virtual machines and can back them up while they're running. Copies of the backups can be handed to developers to test changes on what was, until just a day or two ago, the current production system.

Even if you don't run your server as a virtual machine, you can still make a copy of it as a VM.

However, I'm not kidding about requiring a liberal attitude about disk space. The image files are in the tens+ Gb range and sometimes much higher. Keeping track of dozens of copies requires some advance planning.

-- Craig Yellick
hnhaney2
hnhaney2
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 280
VM ware or some other Virtual PC. is the Key to Backware Capablity.
Make a Virtual PC Copy of the computer at Install with just App. -No Data-
Kepp Virtual PC Patched and Update the Same as the Rest fof the Servers.
Back up after Each Patch and Update Cycle.

Then when the problems come you can roll back the Virutal PC to the Time Needed.
Charles Kincaid
Charles Kincaid
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2591 Visits: 2384
I really don't have a great recommendation on how to handle this other than build some automated system that tracks the current build number on a daily basis, perhaps even putting it in each database.

Put it in the database? Laugh You mean the one we CAN'T restore?

How about a central database to store all your version data and history? If you want to make it independent of SQL Server version issues try MySQL. Or :shudder: Access. Excel does not have any version problems. Whistling Maybe a Text file. Wait, there's all that UTF-8 and Unicode business. I know! PUNCH CARDS! Where are those 15 dozen boxes of blanks? Ahh, back of the car for weight in the snow. Everything is good for something.

Side bar: Why did they think the stand up comedian committed suicide? He killed himself.

Seriously though, reading legacy formats is, and likely always will be, a challenge. Just the other day a legacy application that has been running flawlessly for years went belly up. It threw errors talking about "linked tables". The guy working the issue asked me, "What the heck are linked tables?" The client had to dig to find the Access CD and actually install it on the machine in question. Access pointed to two different MySQL databases and some tables on the AS-400. One of the MySQL tables was corrupt and needed a table repair.

ATBCharles Kincaid
David Reed-223505
David Reed-223505
SSC-Addicted
SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)

Group: General Forum Members
Points: 470 Visits: 380
A little operational maturity goes a long way. If you're following MOF or ITIL, you're already keeping track of all these "little" details and should be able to reconstruct your environment from the logs to line up with those backups.

Having years and years of backups is a start, but...

That said, I don't think I've ever seen an operational shop (even in large enterprises) above a maturity level of ~2.5.
DCPeterson
DCPeterson
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2667 Visits: 432
This is just one reason why change control is SO important. If you have a method of testing and documenting all changes made in your enviornment then it becomes pretty simple to look at the date of the backup file and match that with the state of the server at that point in time.

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek



*****************/
Benjamin Lotter-629969
Benjamin Lotter-629969
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 255
We have implemented an SQL Server instance inventory systems which consists of an SSIS polling mechanism and a centralized database repository. Among the many things we track on a daily basis is the SQL version and build.

Benjamin Lotter
http://BenjaminLotter.info/
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
Steve Jones
Steve Jones
SSC Guru
SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)

Group: Administrators
Points: 106913 Visits: 19332
Typically the version differences don't prevent the restore of a db, however they can affect the functionality.

I used to track this daily, mainly to make sure devs and others didn't change boxes without permission

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search