ah sorry- misread that... all x86 (OS and SQL Server)

permon SQL Server Memory Manager: total memory...

I agree with Steve- I would do it by logging on to the sql server as the agent service account, then from start>run enter "\\server_name\Priya" just like in your...

Sushant-

the error message you are seeing "

Msg 64, Level 20, State 0, Line 0

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 -...

Hmm, think it's tricky to do it that way... What kind of account is the SQL Agent running as? Is it a domain user?

for the record, I said that in the first reply to this post... (bak, not .bak)

Maybe you have the checkbox to "Create subdirectory for each database" checked in your backups, but dont have the "check subdirectories" checkbox checked for the cleanup task?

Test this way: ...

Yep- I've done the exact same thing on other situations- and that would be ideal- but I don't think there is enough room on the server for that.

I bet there is some query I can run against sys.allocation_units to tell me what's near the end of the file (?)

So my question then is this: lets say 90% of objects have been moved to another file group. and 1 object is the last in the datafile. ...

what version of SQL Sever?

Can you perform "Select serverproperty('productlevel')

using GUI with "released unused space" finishes in seconds and makes no change. Maybe this is equivalent to "with truncateonly"... which also has no result. I think there...

never tried shrinking file through the gui.... I usually do "dbcc shrinkfile (filename, targetsize). Maybe I'm just not being patient enough.

After a successful copy, the .bak file should be the exact same size.

still nothing huh?