DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
SITE SEARCH SQLUSA.com HEADLINES NEWS
SQL E/BOOKS   SQL 2014 PROGRAMMING   DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS
How to backup a four terrabyte database?

The following backup plan is recommended for very large Microsoft SQL Server databases with traditional business hours operation:

  Full backup Saturday morning

  Differential backup Mon-Thu nights

  Transaction backup hourly Mon-Fri 8am to 6pm

-- SQL full database backup

BACKUP DATABASE [AdventureWorks2008]

TO  DISK = N'F:\data\AdventureWorks2008\backup\AW8.BAK'

WITH NOFORMAT, INIT, 

NAME = N'AdventureWorks2008-Full Database Backup',

SKIP, NOREWIND, NOUNLOAD,  STATS = 10

GO

 

-- SQL diffential database backup

BACKUP DATABASE [AdventureWorks2008]

TO  DISK = N'F:\data\AdventureWorks2008\backup\AW8D.BAK'

WITH  DIFFERENTIAL , NOFORMAT, NOINIT, 

NAME = N'AdventureWorks2008-Differential Database Backup',

SKIP, NOREWIND, NOUNLOAD,  STATS = 10

GO

 

-- SQL transaction log backup

BACKUP LOG [AdventureWorks2008]

TO  DISK = N'F:\data\AdventureWorks2008\backup\AW8T0900.BAK'

WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorks2008-Transaction Log  Backup',

SKIP, NOREWIND, NOUNLOAD,  STATS = 10

GO

------------


Exam Prep 70-461
Exam 70-461
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE