Information on sys.databases

Using sysdatabases one can create script various scripts one of the useful is to create script to backup all databases.

select name, 'BACKUP DATABASE ' + name + ' to disk=' + '''c:\sqlbackup\' + name + '.bak''' from sysdatabases;

Here is documentation on sys.databases on different SQL Server versions.
sysdatabases (SQLServer 2008)
sysdatabases (SQLServer 2005)
sysdatabases (SQLServer 2005)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.