Thank you. Pushing the whole inner loop into dynamic sql seems to have worked.

Luckily there is a version of the DB on DEV. A few changes need to be applied to it again so it's not too bad. I told the developers to...

I thought the same thing but I have 2 days of differentials and no full.

GilaMonster (8/10/2011)

---

What happened to the full backups? A differential backup cannot have run unless a full...

This is what I want and I know how to do this but this procedure is a manual way. I need it automated. I am trying to schedule a task...

The check db passed successfully and I tried to run a shrink with (emptyfile) so it would distribute the tables to the other filesets that are considered Primary and it...

I think the tables that are in error were able to be dropped or recreated. We are currently running another checkdb to see if any new errors occur after we...

CHECKDB found 0 allocation errors and 294 consistency errors in database 'History'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (History).

DBCC execution completed. If DBCC printed...

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:11154047) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (type In-row data) was...

Thanks this method fixed the issue we were having. Thanks again.

dwh-1095413 (3/22/2010)

---

Thanks I plan on restarting the services later on tonight and testing. I will post afterwards if this fixed...

Thanks I plan on restarting the services later on tonight and testing. I will post afterwards if this fixed the issue or not.

However, if this does not fix the issue...

The @@servername is not the same. I have run the 2 queries but I cannot restart sql server until after office hours.

I will see if this is causing the issue.

Jason...

This query returns 7 results:

id 0 is the name that the local server should be. The is_linked column is 0.

The rest are linked servers and the is_linked is set to...

Yes well they are testing SQL2008 so we can get some compression on the backups. Thanks for your speedy help with this matter. I believe doing a copy_only is exactly...

These databases are very large and very active and they want local full backups for them to restore from but they also want to keep a history of the databases....

Thank you I think this may be what I need.

homebrew01 (11/3/2009)

---

Here's a rough draft starting point for you:

select bset.database_name, bset.Type, convert(varchar(25),backup_start_date,101),convert(varchar(25),getdate()-1,101) , media.physical_device_name

,bset.*

from msdb.dbo.backupset bset

join msdb.dbo.backupmediafamily as...