asked on SQL Backup
Hi,
I am using sql 2005,I run this file daily "Backup Procedure.sql" to take a backup,once i run this file sql management studio will open there i click on execute..then backup will happen.
I would like to know, is there any log file created for sql backup and where those logs stored.
Thanks in advance
GKRT
I am using sql 2005,I run this file daily "Backup Procedure.sql" to take a backup,once i run this file sql management studio will open there i click on execute..then backup will happen.
I would like to know, is there any log file created for sql backup and where those logs stored.
Thanks in advance
GKRT
Microsoft SQL ServerMicrosoft SQL Server 2005Disaster Recovery
Last Comment
Aaron Shilo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Moreover if you are using Litespeed to take backup, there are separate set of tables for Litespeed (created in msdb only) that would have complete information about backups taken like name of backup file, size of backup and timestamp of backup etc.
here you are talking about DB backup??
the sql server logs under Management->server logs
have entries for your backup.
have entries for your backup.