Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
USVICHRIS
Starting Member
2 Posts |
 Posted - 2012-02-09 : 13:20:33
|
| Hi all,Ive been tasked with creating a backup pool of all of our company databases that will no longer be in service because the company is closing. The data from the database will probably never be used again but we have to save it for legal and environmental information. I was wondering if it made more sense to just keep the copies of the MDF and ldf files instead of the .bak files. does anyone know of the pros and cons to either approach?Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-02-09 : 13:28:46
|
| BAK will be smaller. If this is the OneAndOnly backup copy make sure you restore it and DBCC CHECKDB it to make sure it restored OK before dropping the original database. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-09 : 13:49:30
|
| And make multiple copies |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-02-09 : 14:16:17
|
| Make sure to keep copies off-site too, on tape or disk or some other media that will last as long as you need it. |
|
|
|
USVICHRIS
Starting Member
2 Posts |
Posted - 2012-02-09 : 14:58:40
|
| Thank you all for you comments and advice |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2012-02-09 : 16:41:48
|
| You might want to save copies of the SQL Server installation media. No telling how far into the future you will be able to restore a current SQL Server backup onto a later version of SQL Server.CODO ERGO SUM |
|
|
|
|
|
|
Options for Database that will no longer be used