Thank this author by sharing:
By shanu hoosen, 2011/02/11
The below script, once given a path to store the backup files, will dynamically script and execute all non-system databases and append the date and time.
To include system database remove 'where sid <> 0x01' from the query
Create this proc on the Master DB. Don't forget to prefix with USP.
Hope this helps :)
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
