backup of all the database in server

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 2000 Forums

SQL Server Administration (2000)

backup of all the database in server

Author

Topic

oracle_corrgi
Yak Posting Veteran

98 Posts

Posted - 2006-08-24 : 00:17:52

hi

can any one let me know how to take backup of all the database in server eg:node1

once .

thanxs

prabhu-bangalore

database

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-24 : 00:40:16

Tara has written a great stored procedure for this

http://weblogs.sqlteam.com/tarad/archive/2004/08/04/1876.aspx

Here blog is full of other very useful administrative scripts also.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources