We're not trying to continue that insert now, just trying to get the log truncated as would normally happen with a log backup. Any suggestions?

I don't have Integration Service instances to deal with, just maintenance plans created in sql 2005 which are still in sql 2005 servers that I'd like to manage and edit...

I have both tools, but that seems pretty inconvenient. Not many are going to migrate all sql 2005 databases to sql 2008 overnight.

My main concern is maintaining and editing maintenance plans in SSMS 2008 that were created in sql 2005 SSMS.

I was looking for some "automated" help when, in a disaster, you need to restore a full backup, most recent diff and dozens of incremental ( tlog ) backups to...

ah, thanks Silverfox. I should have done a restore like that to be absolutely sure everything worked. Our full backups ( and restores ) take several hours so...

So lessons: 1) remove file and filegroup from database before doing anything that makes the lun/drive unavailable

2) if you fail at #1 the database appears to remain available but...

Systems reactivated the LUN and the drive letter to it. But since the ndf file was in the root of that instead of in the correct subfolder, the database...

I'm waiting for our Systems team to reactivate the M drive to this LUN, which they can't do without restarting the cluster service, so tonight. It does seem that...

no data in the file I'll try restoring the weekend full backup somewhere else in an effort to get a copy of the test ndf file.

We have backups but definitely would rather not go down that route. I'm waiting to see if our Systems guys can bring the LUn back up. Now if...

can't remove the file because the M mapped drive to that space is not there. I don't know yet if the file is still on that LUN and...

I have suggested LiteSpeed. We'll see if I can get the $$ approved. FTP, now that's interesting. I'll ask our Systems folks about that. Most...

The database structure is a work in progress. New file groups were added in May along with other schema changes, initially while in full recovery. Despite log...

Let me preface my comment by saying that I'm a senior (older ) database professional. I can see the value of smaller devices for notification, but I am more...