Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlserverbackup [2014/10/26 01:52] (current)
Line 1: Line 1:
 +===== SQL Server Backup Script =====
 +<​code>​
 +DECLARE @DBName varchar(255)
 +
 +DECLARE @DATABASES_Fetch int
 +
 +DECLARE DATABASES_CURSOR CURSOR FOR
 +    select
 +        DATABASE_NAME ​  = db_name(s_mf.database_id)
 +    from
 +        sys.master_files s_mf
 +    where
 +       -- ONLINE
 +        s_mf.state = 0 
 +
 +       -- Only look at databases to which we have access
 +    and has_dbaccess(db_name(s_mf.database_id)) = 1 
 +
 +        -- Not master, tempdb or model
 +    and db_name(s_mf.database_id) not in ('​Master','​tempdb','​model'​)
 +    group by s_mf.database_id
 +    order by 1
 +
 +OPEN DATABASES_CURSOR
 +
 +FETCH NEXT FROM DATABASES_CURSOR INTO @DBName
 +
 +WHILE @@FETCH_STATUS = 0
 +BEGIN
 +    declare @DBFileName varchar(256) ​   ​
 +    set @DBFileName = datename(dw,​ getdate()) + ' - ' + 
 +                       ​replace(replace(@DBName,':','​_'​),'​\','​_'​)
 +
 +    exec ('​BACKUP DATABASE [' + @DBName + '] TO  DISK = N''​c:​\db backup\'​ + 
 +        @DBFileName + '''​ WITH NOFORMAT, INIT,  NAME = N'''​ + 
 +        @DBName + '-Full Database Backup'',​ SKIP, NOREWIND, NOUNLOAD, ​ STATS = 100')
 +
 +    FETCH NEXT FROM DATABASES_CURSOR INTO @DBName
 +END
 +
 +CLOSE DATABASES_CURSOR
 +DEALLOCATE DATABASES_CURSOR
 +</​code>​
 +
 +----
 +  * [[imaging|Back to Imaging/​Sysadmin]]
  
sqlserverbackup.txt ยท Last modified: 2014/10/26 01:52 (external edit)
CC Attribution-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0