SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 

1562 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

Check Overdue Databases Backup List For Multiple SQL Servers

We can use this SQL Script to get Overdue databases list which have not been backed-up from last 24 hrs. Note ... Note: We can change the Rotation in this SQL Script. We can use this SQL Script as input in SQLCMD/OSQL command as: Put Overdue database SQL query into "C:\temp_rahul\Overdue.sql ... S = Server Name here is "local\sql" -U = User Name here is SA ...

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

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

Delete Backup Files From Default Backup Location

... days) RUN: EXEC [usp_retention_backup]