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