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

1317 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

Backup Database Size calculation Report - Monthwise

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

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

Backup Both Full and TLog Database Backup within a single Job

... myself as I need to take full backup along with transaction log backup using single job and I found ... hourly basis. Thanks, Nitin Gupta (SQL DBA - 2000/2005/2008)

SCRIPT

Query to check whether my Full Database Backup is running fine.

... help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.

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

Sending mail using CDONTS and Sql Server

... used to send mail through CDONTS and SQL Server. It resides in the Master database and accepts ...

SCRIPT

Monitor your website or any URL from SQL Server

code should be added as t-sql step of the job and schedule it for every 5 ...

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 ...

SCRIPT

Automatically Restore Backup Files for SQL 2005

... script which will automatically restore multiple backup files in 1 go which is only available for sql 2000. What this script does is the same thing but for sql version 2005