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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 back up basics FULL DIFFERENTIAL TRANSACTIONAL

Author  Topic 

briankind
Starting Member

17 Posts

Posted - 2009-07-25 : 18:59:15
why do you need all 3?
can I just do a full back up every saturday?
why do i need DIFFERENTIAL or TRANSACTIONAL?
thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-07-25 : 20:35:38
Please look booksonline for backups.
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-07-26 : 05:47:56
What happens if just do a full backup every saturday, and the database fails on the friday morning?

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -