Multiple backup files...
-
Hi
I have setup a maintenance plan that runs every night and store backup on disk on another server.
Now I see that my sql_backup catalog contains multiple files from the same database.
I have 4 databases and in my sql_backup catalog I can see something like:
Name Size Type
<database1> 2 155 801 kB File
<database1>_db_200409260302.bak 2 011 282 kB Bak File
<database2> 1 002 123 kB File
<database1>_db_200409250207.bak 1 040 032 kB Bak File
<database2>_db_200409260312.bak 1 024 403 kB Bak File
Am I right when I assume that database2 File is the original and that the other one can be deleted? Thus I could delete <database1>_db_200409250207.bak but not <database2>_db_200409260312.bak ????
I also see to my big surprise that one of my databases does not have any bak file at all, while all the othe has one..
Regards
Dan
-
Name Size Type
<database1> 2 155 801 kB File
<database1>_db_200409260302.bak 2 011 282 kB Bak File
<database2> 1 002 123 kB File
<database1>_db_200409250207.bak 1 040 032 kB Bak File
<database2>_db_200409260312.bak 1 024 403 kB Bak File
From what I can tell, it looks like you have db1 and db2 and then backup files for db1 and db2. Db1 has backup files for 2 days the 25th and 26th.
Db2 only has the 26th.
If you are offsiting your backup files, or backing them up to tape for Disaster Recovery, then you should only need to have 1 version on your local disk.
My recommendation would be to backup to a different directory than the one your data files exist on. This is in case you lose that disk and then you are toast because your backups are on that lost disk.
In your backup jobs, you can schedule retention times. Figure out what works for you and your company's Disaster Plan, then implement it rigidly.
Good Luck
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply