SQL Server Performance Forum – Threads Archive

quick backup script for master, msdb, model

i remember seeing a really short maybe 2 line script that will
backup the sysdb’s into a folder as .bak does any one have ideas on what that was? thx in advance. – SQL.Admin – US.Florida

---

Anyway it will not be a huge issues of backing up those.
may be following lines are more than "few" lines. still it is simple BACKUP DATABASE master
TO DISK = ‘E:MSSQLBACKUPmaster.BAK’
WITH INIT
BACKUP DATABASE msdb
TO DISK = ‘E:MSSQLBACKUPmsdb.BAK’
WITH INIT BACKUP DATABASE model
TO DISK = ‘E:MSSQLBACKUPmodel.BAK’
WITH INIT
—————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

---

yeah… thats about what i have here, but there was
a script i’ve seen a while back where all 3 db’s were
incapsulated under a couple lines, and worked great. incidentally they were backing up to 3 .bak files
as normal, but under 3 lines of code. thanks for the feedback though i’ll stick with this. just curious about it. – SQL.Admin – US.Florida

---

Good information,
Need to search —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

---

Good information,
Need to search. —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

---

]]>