Jeff, hi. This is the code the vendors sent thru for the delete which just does not perform and I hope can be improved upon

delete from T1

from AssociationLinks T1, AssociationLinks...

yep, that sounds the most likely. a big enough database and judicious use of dbcc sqlperf(logspace) could prove it.

rhlangley (5/16/2008)

---

I just read about this the other day. When a full backup is started, the current (at that time) LSN is noted. The backup is completed. ...

maybe in 2005 log backups that occur whilst full backup is running don't truncate the log?

little hamsters writing it all down more likely though.......

you are the DBA, he's the network admin, end of story. I would not let a network admin, or anyone else, any where near my backup jobs.

If its your responsibility...

how about

select db_name() --returns dbname of current database

or db_name(dbid) will return dbname for that dbid

see BOL

In SQL 2000 log and full backups were mutually exclusive. I would say this is because the full backup process works by just dumping out the extents in the database...

you're not an oracle shop just getting into SQL are you? This sounds like a suggestion from someone used to Oracles multiple schemas in a database to effectively give multiple...

Marios,

I think your mistake was physically moving the tempdb files manually. Just ensure the new directory structure exists (actually if they don't alter database will fail), run alter database and...

Hi people,

it was the dynaminc sql causing the loop to be wrapped in an outer transaction, causing the whole thing to roll back when cancelled.

I put the actual delete statement...

spring just sprung here , glorious weather, 25 centigrade, more like...

in case there is anyone else out there who would rather their proccache was not cleared down just because they restored a log backup, the connect suggestion has moved to:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=342832

Karl,

Hi, hows the weather down there?

I see only two reasons for going for multiple instances, security issues and apps needing to run at different release levels. I guess you have...

not directly because the restore will overwrite whatever is already there if database already exists and a restore does not use model database.

Not sure how restore is done (via EM,...

so have you tried...