Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 

1490 Results Found

SCRIPT

Differential Backup Store Procedure for SQL Server 2000

... sp by inserting correct path insteat of (Backup Path) 2. Create a new job ...

SCRIPT

Complete Details About Backups Taken a Day Ago

... some useful details like:- 1. backed up page count 2. compression ratio ... KB/sec 4. Device where the backup was taken. Etc..

SCRIPT

Automatic restore database to different server from backup file

... N'c:\work\data',--folder for store backup file   @onlyFUllbakup = N'N',   @ServerName = N'ServerA',--for server which backup file come from, it is for step 3 ...

SCRIPT

Database Backup Information Scripts

Scripts can be used to view the backup history from msdb

SCRIPT

Display Databases with X days without backup

... know wich databases have not been backed up within the last X days. You ... wich databases have never been backed up. You must run like: EXEC msdb.dbo.get_backup_info -X where X are the days ...

SCRIPT

PowerShell Query to remove backup folders against multiple servers

... path and output path Change the location of the backup folders as per your requirement Run ...

SCRIPT

Delete Backups Older than N Days

Open SQL Server Management Studio COPY and Paste ...

SCRIPT

Delete Backup Files From Default Backup Location

... days) RUN: EXEC [usp_retention_backup]

SCRIPT

Generic SQL backup with Azure support

... MUST ENSURE THAT THE -- AGENT JOB FOR ALL BACKUPS RUNS UNDER THE CONTEXT OF A SYSADMIN USER ... your Azure account in order to perform -- backups to this location. This must relate to the Blob storage ... library/jj919149.aspx ------------------------------------------------------------ -- EXAMPLE CALL TO SP VIA a SQL SERVER AGENT JOB STEP ------------------------------------------------------------ --Differential ...

SCRIPT

Backup Growth Trend Check

Copy the script in SSMS to any of the SQL Servers Run it. Use the results based ...