Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 

1424 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

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 Backup Files From Default Backup Location

... days) RUN: EXEC [usp_retention_backup]

SCRIPT

Backup Growth Trend Check

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

SCRIPT

Backup Database Size calculation Report - Monthwise

Execute the entire script using SQL Server Management Studio. Do not remove ...

SCRIPT

Check Backups

procedure will check the last full backups and report databases that have not been backed in a certain amount of days. The prodedure will also ... also report on databases that have not been backed up at all. Please feel free to make ...

SCRIPT

Monitor Any Linked Server From SQL 2000

Hi, DBA's often monitor Backups, Replication e.t.c manually or through some ... sp_TestLinkedServer) to test linked servers in SQL 2005 will say pass even the Access ... you to monitor Linked servers from SQL 2000 and i have posted another SQL 2005 version of this script. Also fine ...