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 |
|
booyeeka
Starting Member
10 Posts |
 Posted - 2008-03-12 : 11:36:54
|
| hi all,i have some questions about backing up mssql database, please, if you can help me with them.1. what is main difference between Full Recovery and Bulk_Logged Recovery models? when to use one, and when to use the other?2. why do i need marks in my backup? can you tell me in which case do i need marks? i don't understand, why wolud i ever wanted to recover database to some marked point? in which case i would like to recover only it's part and not full database?3. if i do have backup of transaction log, it means nothing if i do not have backup of database structure? i need to have complete backup of transaction log to be able to recover all of the data?4. i have database, and i did make no changes in database structure. in that case, only one backup of the system tables of the database is enough? there is no need to backup it all the time?5. when i backup my transaction log file, do i backup only a differences between last backup of transaction log file and current, or i always backup complete transaction log file?thank you in advance! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-12 : 11:54:04
|
| http://www.sqlteam.com/article/introduction-to-sql-server-database-backups_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
booyeeka
Starting Member
10 Posts |
Posted - 2008-03-12 : 15:22:37
|
| ok, tnx, but can you give me some exapmles when do i have to use Full Recovery and when Bulk_Logged Recovery model?also, i wolud love to know when will i need to recover data just to some point, and not to recover all of the data from backup?thank you in advance!p.s. hvala unapred |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-12 : 15:30:21
|
well the answer is always it depends to both of your question.the choice of the recovery model and point in time recovery depends on what your business requiremets are.with full recovery model you can restore the database to an exact point in time provided you have transaction log backups.bulk logged only minimaly logs any bulk insert operations (only logs page allocations), and you can's use any transaction log that has bulk import data in it to restore to the point in time.so if you must really have a point in time recover ability use full.> p.s. hvala unaprednema na cemu  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
|
|
Several newbee questions about MSSQL backups