Here is how I parse the name of the backup file

Select @vDBName = DatabaseName From @vDBList Where DBID = @vCount

Set @vNewpath = @vBackupPath

Set @vFileName = @vDBName + '_Full_' +...

Just as a general question, couldn't you use a maintenance plan to do the backups and deletes of the old backups?

Thanks Jeffery, it worked for me also.

Taking SSCommitted's code and wrapping it in a sp_msforeachdb you can run the below:

sp_msforeachdb '

SELECT ''?'',c.physical_device_name , a. backup_start_date

FROM msdb.dbo.backupset a join msdb.dbo.backupmediaset b ON a.media_set_id = b.media_set_id

JOIN msdb.dbo.backupmediafamily...

So you are saying that this ran yesterday and the day before and etc but now it won't run. If this is the case, then someting has changed, probably...

After reading the editorial and the comments I have somewhat mixed feelings and am struck with these three thoughts:

1.) It's not my job, it is my employers job and...

Try the following from a query window on the database in question

create table #temp(tablename varchar(120), reccount int)

go

sp_msforeachtable 'insert #temp select ''?'',count(*) from ?'

select * from #temp

select * from mytable with (nolock)

or

select * from mytable (nolock)

I would keep 4 or 5 days worth of backups, upcoming Thanksgiving holidays, case for 5 days worth.

Technically, after it is copied to the secondary location it is...

The choice to have the log shipping be standby or restore mode is made back when you are initially setting up log shipping. It looks you need to look...

Steps for failover:

Run the copy job and also Run the restore job at the same time. Ensure that there are no more files to copy or restore.

run restore with...

So, I think that your question is, how do you restore the log files to the offline copy when the restore job is turned off during the day? Currently...

The error message about not in recovery mode is telling you to start again :(.

In log shipping the secondary database is usually either in standby, ( users can...

When setting up log shipping, the SQL Server Agent SERVICE owner needs to be a login with enough rights on the other server to be able to copy files to...

For your reporting, replicated database, you might want to create another database on the subscriber server and keep all report definitions, sp's, views, stored procs in this database, referencing the...