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 |
|
nnmmss
Starting Member
3 Posts |
 Posted - 2012-11-26 : 04:57:06
|
| I want to have backup from a Database, so i did as following1- I made a full backup from database2- I make a differential backup every week from database3- I make a Transaction log backup every every 6 hours, because my database is not so bigmy first question is that is the above plan correct?second question is that when i create a full database backup a file named database.bak is created in a path and i want to make Transaction log Backup, I find the same database.bak in "destionation backup to" which is the bak file that was created in Full Database backup. and again there is just that previous database.bak file in the path.is it correct? shouldn't any *.trn file be created in the path when i create a transaction log backup? |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2012-11-26 : 15:23:13
|
| If your database is not that big/large as you state in your post, why do differential or transactional backups at all? If its not that big and is not modified frequently why not just stick to full backups only? |
 |
|
|
johnson_ef
Starting Member
16 Posts |
Posted - 2012-11-30 : 06:15:25
|
| About first question:You are the best person to judge about backup strategy. You can say about your environment. Still I would recommend for daily differential and hourly T-Log backup.this will easy for recovery time to manage easily to work with minimum number of files. Also place a schedule for Full backup Monthly or Weekly if the DB size is not big.About second Question:You can change the Backup file name and its extension. Some Practices, which I have noticed, is, for Full backup, DBA will give as .bak and for Differential as .DIF and for Transaction-Log .TRN. You can name it as you want and even extension doesn't matter at all. May be you are looking the name in the Interface\GUI, please remove the filename with 'Remove' button and you can add new name\extension there.-Johnson |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-11-30 : 07:06:51
|
| Diferential backup every week is very odd. If the db is not big then do fulls every time.I would generally do at least a full weekly and diff daily whatever the database. If you lose a backup all the diffs following are useless and you have to use all the tr logs up to the previous valid full/diff combination - too much can go wrong with your scenario and it means going back a long way when you make changes.TR log backups are not really to do with the size of the database but how frequently updates are made and how many changes you can afford to lose.I would timestamp the backup files<dbname>_<BackupType>_yyymmdd_hhmmss.bak==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
bak and Trn file