... sp by inserting correct path insteat of (Backup Path)
2. Create a new job ...
... some useful details like:-
1. backed up page count
2. compression ratio ... KB/sec
4. Device where the backup was taken.
... path and output path
Change the location of the backup folders as per your requirement
... 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 ...
... 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 ...
Execute the entire script using SQL Server Management Studio.
Do not remove ...
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 ...
... 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)
... 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.
you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you ...