I've got the same issue! Hoping for a response. Help! 🙂

No doubt about it! This is a situation where another organization was moving their DB to our server and sent us the backup like this. I had never seen anything...

Lynn,

Thank you for the assistance! I looked everywhere, and even had FILE=11 sitting here in a query screen, but wasn't understanding that that was the answer until I read your...

Okay, here it is - let me know if you need any more than this.

restore headeronly from disk='d:\FullBackupAllDB.BAK'

BackupName

master_backup_20100523040035

model_backup_20100523040035

msdb_backup_20100523040035

DB1_backup_20100523040035

DB2_backup_20100523040035

DB3_backup_20100523040035

DB4_backup_20100523040035

DB5_backup_20100523040035

DB6_backup_20100523040035

DB7_backup_20100523040035

DB8_backup_20100523040035

DB9_backup_20100523040035

DB10_backup_20100523040035

DB11_backup_20100523040035

(14 row(s) affected)

restore filelistonly from disk='d:\FullBackupAllDB.BAK'

LogicalName

master

mastlog

(2 row(s) affected)

Lets say I want DB9_backup_20100523040035...

Another issue to watch for is to be sure that the process running the backup has permissions, such as when you have the SQL Server Agent running the backup from...

Now I know! And knowing is half the battle!

Check out: http://msdn.microsoft.com/en-us/library/ms159206(SQL.90).aspx and http://support.microsoft.com/kb/909678

Currently I'm going with the option of changing the memory settings in rsreportserver.config file.

I'm looking for this answer, too. Is it a limitation of reporting services? I'm watching memory usage and processor, but its nowhere near looking like a problem of used-up resources....

Okay, got it! Instead of worrying about username/password for the extensionsettings, you're just editing a pre-existing subscription. Guess I was working too hard at it! 😛

Thanks for the assistance and...

Apparently its blocked by my workplace (the govt). *grumble grumble*

Are you referring to the following: http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html?

This is the one that I cannot open. I imagine its just the one I need, so I was hoping someone could...

Hello,

I wrote something similar as your procedure and ran into the same problem you were having with the username and password encryption for the createSubscription procedure.

Has anyone figured out...

Yes it is. I will give bcp and bulk insert a try. I appreciate your input.

Thanks!

Randy

I have considered it, but it seems to be the wrong answer for during-production inserts because of having to drop indexes to really see the benefit.

Its a network account.

Yep - I've been meaning to check out Gail's blog. Unfortunately, it's blocked to me from work and no access at home.