This works fine for me.

exec xp_cmdshell 'COPY "\\fordiavcenter41\backup\*REPORTSERVER*.bak" "Q:\Backups SQL"'

There's only 1 thing to keep in mind really.

If you use a CTE and then refference the CTE twice in the query's from clause then that query will be run...

http://www.sqlservercentral.com/articles/T-SQL/68467/

Buy more disk

Extend the current disk on your san

Delete useless files or data (which is almost never the DB).

What files were you trying to shrink?

Do you take regular tlog backups...

C.K.Shaiju (8/1/2011)

---

🙂 lol. I like that. But this just clear my curiosity 😀

Assume we do not...

How much ram do you have on the machine now and why do you think sql server is starving on ram?

I was polite, my first bet was 1K +.

I felt I had a better shot to get a yes at 100$ :w00t:.

Still waiting to see the actual execution.

I...

Are those users connected on a db with log-shipping?

Do you kill connection to resolve blocking?

Do you reboot the server (or service) on a regular basis?

And the error is?

Pavle-192195 (8/1/2011)

---

Thanks, I'll check the disk and see what the diagnosis says.

That's for the I/O error but what about the DBCC CHECKDB not creating the snapshot ? Also related to...

What kind of help do you need exactly?

Should not be an issue... again what have you triedand what's the error?

Yes it' clearer, but if the platform is not chosen yet Access is a fast and easy tool do to that in

What do you mean? If there's 1 space anywhere in the path youhave to put everything in quotation :

"C:\whatever space\file space .txt"

What command are you trying to pass...

What exactly do you need to do? Access is possibly a good option but I don't really understand what you need.