Thanks sturner, I was afraid of that answer.

Any creative workaround(s)?

Those options will not work for us. The process from the HP SAN side is as follows:

1. Somehow put the SQL Server databases on write-suspend mode (or some...

Thanks a lot, have downloaded the white paper, looks very detailed!

Hi Adiga,

Thanks for the link, I like your site and the articles.

Thanks guys for your help and the quick responses.

Sorry for the late response.

There are about 200 tables. Weird thing is that when I looked at the objects in memory, one of the sys* tables (forget...

Hi Steve, you are right, and I am sorry for not thinking this out clearly. Here's what we are trying to do:

We have a production environment with some 6...

Good point! Thx.

Hi, thanks for your response. We have a 300GB database that we want to replicate, with all the objects in it. There are a ton of updates that...

Thanks all, I think that breaking down the transaction to 5 million at a time will be the route I'll go. If I run into problems, I'll report here,...

Hi there,

I see your point. When I change the where clause to indid >= 1, then I get 237MB whereas the file is 158MB.

I have also...

I think in SQL 2000 the indid 255 is for TEXT/IMAGE, but not in SQL 2005.

I ran the query and changed the where clause to:

WHERE indid >= 2

And...

Tx GM, I can confirm that this is not the case. I made a fresh backup to a new file with the overwrite option. I then restored from...

Thank you for your help! This is certainly the first time that I see this kind of definition for these terms. The definitions are usually like "A backup...

Thanks all.

My understanding is that SQL Server logs can and do contain transactions that are not yet committed. However, the log backups only back up committed transactions. So,...