SQL Jobs – SQL Step Commands for StarBuilder

SQL Jobs – Steps Command

Empire backup 6:15P
BACKUP DATABASE [Empire] TO [Empire] WITH INIT , NOUNLOAD , NAME = N’Empire backup’, NOSKIP , STATS = 10, NOFORMAT

EmpOps backup 6:45P
BACKUP DATABASE [EmpOps] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\EmpOpsBU.BAK’ WITH INIT , NOUNLOAD , NAME = N’EmpOps backup’, NOSKIP , STATS = 10, NOFORMAT

EmpOps On Demand backup (disable)
BACKUP DATABASE [EmpOps] TO DISK = N’D:\Microsoft SQL Server\MSSQL\BACKUP\EmpOps_OnDemand.BAK’ WITH INIT , NOUNLOAD , NAME = N’EmpOps backup’, NOSKIP , STATS = 10, NOFORMAT

EmpWIP backup 6:30P
BACKUP DATABASE [EmpWIP] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\EMPWIPBU.BAK’ WITH INIT , NOUNLOAD , NAME = N’EmpWIP backup’, NOSKIP , STATS = 10, NOFORMAT

EmpWIP On Demand Monthly Close (disable)
BACKUP DATABASE [EmpWIP] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\WIP_OD_SEP.BAK’ WITH INIT , NOUNLOAD , NAME = N’EmpWIP backup’, NOSKIP , STATS = 10, NOFORMAT

MEmpOps On Demand backup (disable)
BACKUP DATABASE [MEmpOps] TO [mempops_ondemand] WITH INIT , NOUNLOAD , NAME = N’MEmpOps On Demand backup’, SKIP , STATS = 10, DESCRIPTION = N’MEmpOps On Demand backup’, NOFORMAT

Shrink Database – StarKDC
DBCC SHRINKDATABASE ([StarKDC])

StarKDC backup 12PM
BACKUP DATABASE [StarKDC] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\SB1200.BAK’ WITH INIT , NOUNLOAD , NAME = N’StarKDC backup’, NOSKIP , STATS = 10, NOFORMAT

StarKDC backup 5PM
BACKUP DATABASE [StarKDC] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\SB1700.BAK’ WITH INIT , NOUNLOAD , NAME = N’StarKDC backup’, NOSKIP , STATS = 10, NOFORMAT

StarKDC backup 9AM
BACKUP DATABASE [StarKDC] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\SB0900.BAK’ WITH INIT , NOUNLOAD , NAME = N’StarKDC backup’, NOSKIP , STATS = 10, NOFORMAT

StarKDC G/L On Demand Monthly Close (disable)
BACKUP DATABASE [StarKDC] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\SBODGL.BAK’ WITH INIT , NOUNLOAD , NAME = N’StarKDC backup’, NOSKIP , STATS = 10, NOFORMAT

StarKDC G/L YearEnd (disable)
BACKUP DATABASE [StarKDC] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\GLYE.BAK’ WITH INIT , NOUNLOAD , NAME = N’StarKDC backup’, NOSKIP , STATS = 10, NOFORMAT

StarKDC On Demand Anytime (disable)
BACKUP DATABASE [StarKDC] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\SBANYTIME.BAK’ WITH INIT , NOUNLOAD , NAME = N’StarKDC backup’, NOSKIP , STATS = 10, NOFORMAT

StarKDC P/R On Demand
BACKUP DATABASE [StarKDC] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\SBODPR.BAK’ WITH INIT , NOUNLOAD , NAME = N’StarKDC backup’, NOSKIP , STATS = 10, NOFORMAT

StarKDC P/R YearEnd (disable)
BACKUP DATABASE [StarKDC] TO DISK = N’D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\PRYE.BAK’ WITH INIT , NOUNLOAD , NAME = N’StarKDC backup’, NOSKIP , STATS = 10, NOFORMAT

WIPmas backup 6PM
BACKUP DATABASE [WIPmas] TO [wipmas_6pm] WITH INIT , NOUNLOAD , NAME = N’WIPmas backup 6PM’, SKIP , STATS = 10, DESCRIPTION = N’WIPmas backup 6PM’, NOFORMAT

WIPmas On Demand Month End (disable)
BACKUP DATABASE [WIPmas] TO [wipmas_od_monthend] WITH INIT , NOUNLOAD , NAME = N’WIPmas On Demand Month End’, SKIP , STATS = 10, DESCRIPTION = N’WIPmas On Demand Month End’, NOFORMAT

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advertisements

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