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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2011-10-28 : 09:50:22
|
| I need to take a backup for all databases everyday.I need scripts to automate to take full backups of all databases everyday.Thanks for the help in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2011-10-28 : 12:31:47
|
| Thanks VisakhThe link provide the back for one database..I want all the databases on the server to take the backups. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-28 : 12:33:28
|
| is it so difficult to repeat it for other dbs?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2011-10-28 : 14:28:10
|
| Is there a script which backups entire databases instead one by one. I have like more 20 databases. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-28 : 14:39:15
|
| Maintenance Wizard will do this. But it is fragile and seasoned DBAs tend to avoid it.Seasoned DBAs tend to write their own code to do this. There are a number of issues that need solving - you can't take LOG backups on databases that are in Simple Recovery model, and you can;t take Backups, at all, for databases that are Offline. And so on ...You would also like to know if the thing fails for any reason, rather than discovered that you have no backups ONLY WHEN you have a real-life disaster.Tara has some good scripts for this in her Blog:http://weblogs.sqlteam.com/tarad/default.aspxhopefully you can find them, but if not send her a message asking for a link and I'm sure she will help you. |
|
|
|
|
|
|
Scripts