December 11, 2008 at 3:15 pm
We have a sql server 7.0 database that I have been asked to decommission.
Part of my decommissioning task is to backup the data prior to shutdown - incase we ever need to get at the data again.
I have a good 7.0 Full DB backup.
Will I be able to use this to recover the data on any 7+ Sql Server version (2000,2005,2008,20xx)?
Or do I have to tuck away a copy of Sql Server 7 with the backup ?
thanks in advance
December 11, 2008 at 3:23 pm
I would tuck away a copy of SQL Server 7.0 with all the appropriate service packs/hot fixes that have been applied to the server as well. In fact, maybe two copies of each to be safe; stored in separate locations.
December 16, 2008 at 10:37 am
You can restore to 2005, but not 2008.
However, you can restore to 2005, it will drop into 70 mode, then take a backup as a 2005 backup. That should get you a few more years.
I'd do what Lynn suggests and drop a copy of the 70 or 2000 software on the same disk image.
December 18, 2008 at 12:01 pm
hmmm
I have decided to backup on three levels :
* sql server 7 db backup
* export of each table to text file
* ddl sql of all tables, procedures, views, ets
The problem with keeping a copy of sql server 7 db software is that it has OS level requirements.
There is no guarentee that sql server 7 will run on the future release of MS OS.
So then I would need to keep a copy of Windows 2000 Server OS.
But then there is no guarentee that Windows 2000 OS will run on the future hardware - so then I need to keep an old server, and on and on.
So you can see that this is not the solution.
Instead - a coma delimited flat file extract will be accessible to all databases in the future.
December 18, 2008 at 12:07 pm
Windows Server 2000 may not run on future physical hardware, but you should be able, if needed, be able to install Windows Server 2000 on a virtual server.
In fact, you could potentially setup a virtual server now with the Windows Server 2000 and SQL Server 7.0 installed and running, and archive the virtual machine image for future use if needed.
December 18, 2008 at 1:25 pm
Lynn Pettis (12/18/2008)
Windows Server 2000 may not run on future physical hardware, but you should be able, if needed, be able to install Windows Server 2000 on a virtual server.In fact, you could potentially setup a virtual server now with the Windows Server 2000 and SQL Server 7.0 installed and running, and archive the virtual machine image for future use if needed.
Beat me to it - I was going to suggest building a VM and backing up the VM. Anybody know how long a VM built today would be good for? Are there any known issues with trying to run VM's that were created years ago on newer versions of the host software?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 18, 2008 at 2:33 pm
Don't think the VM software has been around long enough. You might just need to migrate those VMs periodically, every few years or so
December 18, 2008 at 2:42 pm
That would be the only concern I would have - but, if all you had to do was load up the VM and 'migrate' it to the new platform that wouldn't be too bad.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply