This should work fine for you.Once you create this procedure, just go ahead and create a job and include the step as exec usp_DeleteOldBackupFiles . The code is shown below...

Why dont you try Remote Desktop to that server.

It will not take longer time. Also include the log file name in the command mentioned below, suppose you log file name is MyDB_log1.ldf then the command would become

Use MyDB

GO

BACKUP...

The DBCC Shrinkdatabase command would shrink the size of your database to the specified size. But why do you want to use this command on a live prod database? Usually...

There are many a jobs running on this server. But they've been there for quite some time now. Also I noticed one more thing that the Tlog backup(hourly) took 29...

Volleyball every day with a bunch of frnds..and workout every other day. but once i am done with it i surely go through my daily checklist as in jobs,disk space,backups,production...

Well, to begin with I would see if AMADEUSSBS\administrator has the privileges to run the jobs. And if it does the next step would be to look for all...

i have a scheduled job that kicks in every week.Does reindexing against this table.So I dont think Indexing should be an issue. Well I have worked on with the application...

Mr.Gail,I shall go for more disk space as you mentioned that too with restricted growth. Let me re-do the DBCC statements to include what is sufficient to serve my purpose...

Gail thanks for the reply.As for ur question there are a bunch of DBCC's like CheckAlloc and CheckDB running against each of the 40 odd DB's on this server. At...

Ok, I have cofirmed that there is a .ndf file in the DB's primary filegroup. I have conveyed the msg across to the concerned authorities and that they should ask...

Ok, the job includes two steps

1.

exec usp_WaitForProcess 'backup' ( refer WP.doc attachment for the actual code)

2.

exec usp_BackupDatabases 'full', @VerifyBackup = 0 ( refer FB.doc attachment...

Ok, off all the errors listed in the error log, all I could pin point to the time of the DB's going suspect are as shown below, hope it helps

Device...

Please have a look at the attachments, this shall help. For that even the T-Log backup hace been failing too, which are scheduled hourly. One issue I am having from...

step 1 says : wait for TSQL Process, which calls in a script having SP as usp_WaitForProcesses.

I tried changing the Owner, but it wont let me do it also the...