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 |
|
Vishal_sql
Posting Yak Master
102 Posts |
 Posted - 2012-07-17 : 08:54:39
|
| Hi Friends,I am trying to take backup of SQL Server DB of around 19 GB.4 GB Data File and 15 GB Log file.When i took full-backup of DB ( from Wizard) the .bak file gets created of 4GB.Now I am wondering what does .bak file have? Data file or Log file.I was considering .bak would be around 19 GB.Plz help |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-17 : 09:17:55
|
| Has the data and enough of the log to complete a recovery.Why do you have a 15 GB log file - are you using the full recovery model without log backups?==========================================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. |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-07-17 : 09:30:54
|
the 'log' file is the transaction log of the database. Its not at all like an application log. It lets you replay from point of time etc.By default the dbserver will be in FULL RECOVERY mode. This is generally overkill unless you need point of time recovery. If you set the recovery mode to SIMPLE you will see a decrease in size.SIMPLE still lets you restore to when the backup was taken but you can't replay log after restoring that backup to get to a point of time state.Read this...http://msdn.microsoft.com/en-us/library/ms189275.aspxSeems like you are the DB Person for your company eh? Normally this kind of stuff would be a DBA's responsibility. If you are the only one who cares about the database it can be tough.Lots of us have been there though so hang in there.Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
|
|
|
Vishal_sql
Posting Yak Master
102 Posts |
Posted - 2012-07-17 : 09:57:10
|
| By default the db server is in FULL RECOVERY model.I was concerned about when we take backup of SQL Server does .mdf and .ldf files includes in backup file ?How do DBA normally takes the backup ?Do they take backup of Data files and Log files differently?As I have 19 GB of data. I beleive I need to take backup of all of it ( 19 GB).Plz suggest. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-07-17 : 10:05:57
|
this is a pretty good introduction from a quick scan.http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=40Normally you'd use a third party backup tool or set up a sql agent job to make backups. Depending on the recovery model you need to make log backups / differential backups also.For a simple recovery model database you'd generally have a sql agent job taking backups every so often (x hours apart) depending on how critical the data was. Backuping up to a BAK file or tape drive somewhere (timestamped ofc)you can backup just using sql commands if you like.a sql backup is very different from a server backup -- generally there are 2 or more files per database (a mdf and an ldf file) -- these live files can't really be copied or backed up directly (we'll you may be able to as a last resort but it's not recommended). When you use sql backup you'll end up with a .bak file which can be used to restore the db on it's own.Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
|
|
|
|
|
|
Database backup