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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s