Short Script to Backup All User Databases

,

This T-SQL script backs up all user databases.

exec sp_msforeachdb 'if db_id(''?'')>4 backup database [?] to disk = ''c:\?.bak'' with init, compression;'

Rate

3.14 (7)

Share

Share

Rate

3.14 (7)