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 |
|
Davids_Maguire
Starting Member
14 Posts |
 Posted - 2007-01-10 : 05:47:30
|
| Hi all ,this is my first post here hope i will find help.I'm facing problems in understanding some topics .. and i searched on the net but every time i read an article i find new things and topics.i think i need just a good way to start from the following topics. -recovery models (full,simple,..).-fullback and differntial back up.waiting for your help or even links to external articles may also help.thanks in adavance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-10 : 06:31:45
|
| simple recovery - tr log is truncated on every checkpoint.Full, bulk loged - need to implement log backups otherwise log will grow to fill machine.Full backup will backup whole database and the tr log that is needed so that database can be restored.Diff backs up differences since last full backup - to restore - restore full backup (with standby) then any of the following diff backups.TR log back - these enable you to restore the changes made. They are independant of any full/diff backup i.e. you can restore any full backup then all the following sequence of log backups to restore to the state of the last log backup. This is good as if you have a corrupt full backup you can go back to the previous and as long as you have the sequence of log backups you can still restore to a recent state.seehttp://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-10 : 06:31:58
|
| Check these articles to brush up the basics:[url]http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1069109,00.html[/url][url]http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1076630,00.html[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Kristen
Test
22859 Posts |
|
|
Davids_Maguire
Starting Member
14 Posts |
Posted - 2007-01-12 : 07:23:41
|
| just wanna say thanks all for your helpfull answers |
|
|
|
|
|
|
Need help about recovery Models