On the machine experiencing the issue, I ran a partial on read_write_filegroups and then 8 individual read only filegroup backups. Then, that night I ran the differential without specifying read_write_filegroups...

Thanks for your help!

Jay

It seems that rerunning the backup on read_write only did not allow me to do a normal differential.

I then tried this script with success:

declare @backupfile nvarchar(2000)

set @backupfile = 'X:\...\...\dbname_' +...

I'm sorry if that was confusing... [dbname] is what I am typing here to illustrate the name would be there.

I am running the partial on read_write now to see if...

Hi All,

I have a similar issue, but I am now trying to also return the xml data AS xml with the returned set.

So the expected results would be:

EmployeeID EmployeeName EmployeeAddress...

I think all of this information is great! The only real feature I am interested in at this point is Data Driven Subscriptions. However, we do have a "poor...

Thanks Paul. I think my main point of posing the question here is that the information that I've found detailing "Availability and Scalability" does not really give me enough...

Thanks everyone! These are all great points. I will take these and evaluate the features and determine ROI. Thanks much!

I wanted to thank you both again for the information given. I am planning on researching the CTE a bit more to gain a more comprehensive understanding of the...

Yes, the only reason I am casting these is to make my between clause work for the last day. This data must be stored in the table as datetime because...

Thanks a lot! I was not aware of this and I think it will help me and my team to create more efficient queries.

Thanks,

Jared Karney

Thanks for the quick response!

Unfortunately I am not sure what you mean by CTE... I'm sure I will feel like an idiot when you tell me.

In terms of the...

Ok, great! That makes a lot of sense. We have actually just moved our tempdb to a larger partition so that we can test without affecting our OS partition. ...

stewartc-708166 (6/10/2010)

---

It is a good idea to play around with the batch sizes.

However, the INSERT INTO SELECT FROM is what is consuming the most resources.

you could consider moving the data...

stewartc-708166 (6/9/2010)

---

The BULK INSERT, with BATCHSIZE set to x rows, commits to the destination table after every x rows, thus consuming less memory et al.

INSERT INTO SELECT FROM, however, loads...