how to find out when sql server is backing up databases

[shresthaal]

i want to find out how to change the time when sql server backs up its databases

there is no maitainence schedule or backup scheduled but when i checked the

 

[SQLBill]

First, you didn't finish your post.

Next, if there isn't any maintenance scheduled or backup scheduled...then the only way backups can be done is manually. UNLESS, there is a third-party application doing the backups (not always a good thing).

If your sysadmin is backing up the files (.mdf/.ldf) then those are not true backups and will not be able to be used to restore the database - unless SQL Server services were stopped or the database was detached when the backup was made.

-SQLBill

Posting advice: FAQ481-4875