Database Size
-
Hi All, Recently ,when i try to restore files from my back up (MyDB.BAK) i found two entries one Saying a Fullbackup and another backup which contains the date of backup Why i am getting two different entries i really dont know.Previously,I only used to get a single file for the current date backup. Have i changed something to get a duplicate backup? As the size of the file is now Doulbled from the one i had two months ago? I am just doing a full backup. In short this Backup (myDB.bak) is contains two files of same type.Its a duplicate. As a result its giving me double the size of my DB. Is there any way i could get only one backup? Thanks
-
Hi All, Recently ,when i try to restore files from my back up (MyDB.BAK) i found two entries one Saying a Fullbackup and another backup which contains the date of backup Why i am getting two different entries i really dont know.Previously,I only used to get a single file for the current date backup. Have i changed something to get a duplicate backup? As the size of the file is now Doulbled from the one i had two months ago? I am just doing a full backup. In short this Backup (myDB.bak) is contains two files of same type.Its a duplicate. As a result its giving me double the size of my DB. Is there any way i could get only one backup? Thanks
I suspect you checked append when selecting the destination (in SSMS). When restoring, via SSMS, you can select the backup you want to restore. I am surprised that restoring both set doubles the size of your database though, I would expect it to overwrite.
Never underestimate the power of human stupidity RAH
-
I suspect you checked append when selecting the destination (in SSMS). When restoring, via SSMS, you can select the backup you want to restore. I am surprised that restoring both set doubles the size of your database though, I would expect it to overwrite.
Never underestimate the power of human stupidity RAH
Thanks so much for your response. I did run the database tuning advicer and sql profiler a couple of weekes ago.Can this increase my transaction log files termendeously.At the moment the log files is about 1.1GB,Is there any tool i can use to get the history of this log file in the last few months? Other wise ,How can i shrink the logfile? Is there any other tool i can use which can tell me why database has grown by double size in only few weeks. Many thanks.
-
Thanks so much for your response. I did run the database tuning advicer and sql profiler a couple of weekes ago.Can this increase my transaction log files termendeously.At the moment the log files is about 1.1GB,Is there any tool i can use to get the history of this log file in the last few months? Other wise ,How can i shrink the logfile? Is there any other tool i can use which can tell me why database has grown by double size in only few weeks. Many thanks.
Yes you can shrink the log file - look for shrink in BOL. If you have changed your logging method from simple to full then that will certainly make a big difference.
Never underestimate the power of human stupidity RAH