Depending on version, you need to specify the extension to delete as BAK not .BAK

I think this was fixed in a service pack if I remember correctly.

I think I remember that MS does not recommend restoring across the network. If you have sufficient space, why not copy the file over first?

Hi Gail, you've posted help for me in the past, so I assume you are right and I am wrong, but let me make sure I understand what you are...

correct- can not move w/o clustered index.

Syntax for non-clustered index is same as clustered index, except instead of CLUSTERED use NONCLUSTERED. Of course, you want to drop the existing...

IF you drop and recreate a clustered index, nonclustered indexes are also recreated. This article explains it well: http://www.sql-server-performance.com/faq/rebuild_clustered_index_p1.aspx

Typically, I do this: Script all indexes,...

To list all the tables in a filegroup use:

select distinct(object_name(id)) from sysindexes

where groupid=filegroup_id('<filegroup-name>')

To list all indexes in a filegroup use:

...

You can not move a file to a different file group. You can move a table to a different file group. To do so you need to add...

So to clarify- the "Reserved space" for the table and index as show above is almost 130GB (most of that is "index space"... non-clustered). I should have at...

Thanks for the input.

The table is extremely fragmented- so what I am hearing is what I suspected- even though I will gain space in the end, I still need 1.2Xs...

Did not change the DoS registry key as I was not getting the tell-tale messages in the event logs.

Strange enough- I applied CU 11 and the problem has not recurred.

forgot to mention- also get this in event logs to the two nics:

Event Type:Warning

Event Source:l2nd

Event Category:None

Event ID:4

Date:8/24/2010

Time:8:09:42 PM

User:N/A

Computer:omitted

Description:

HP NC382i: The network link is down. Check to make sure the...

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.replication.snapshotgenerationagent.bcpbatchsize.aspx says:

When performing a bcp in operation, the value of BcpBatchSize determines the number of rows to send to the server as one transaction, and also the...

I may have found it- in the distribution agent there are profile settings for "bcpbatchsize" "commitbatchsize" "commitbatchthreshold".... I bet these are used during snapshot generation and perhaps will impact the...

This isn't a "real" problem- there will be plenty of room for the transaction log to grow on the subscriber... it's more of a theoretical annoyance for me now... I'm...

Yes, I'm including indexes- because of the nature of the application, it is a requirement.