Viewing 15 posts - 4,156 through 4,170 (of 18,926 total)
This works fine for me.
exec xp_cmdshell 'COPY "\\fordiavcenter41\backup\*REPORTSERVER*.bak" "Q:\Backups SQL"'
August 1, 2011 at 5:33 am
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...
August 1, 2011 at 5:30 am
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...
August 1, 2011 at 5:27 am
C.K.Shaiju (8/1/2011)
Eugene Elutin (8/1/2011)
Basically your question is: Can I modify the stored procedure without modifying it.
🙂 lol. I like that. But this just clear my curiosity 😀
Assume we do not...
August 1, 2011 at 5:24 am
How much ram do you have on the machine now and why do you think sql server is starving on ram?
August 1, 2011 at 5:21 am
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...
August 1, 2011 at 5:21 am
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?
August 1, 2011 at 5:17 am
Pavle-192195 (8/1/2011)
That's for the I/O error but what about the DBCC CHECKDB not creating the snapshot ? Also related to...
August 1, 2011 at 2:51 am
What kind of help do you need exactly?
August 1, 2011 at 2:49 am
Should not be an issue... again what have you triedand what's the error?
July 31, 2011 at 3:04 pm
Yes it' clearer, but if the platform is not chosen yet Access is a fast and easy tool do to that in
July 31, 2011 at 9:25 am
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...
July 31, 2011 at 8:50 am
What exactly do you need to do? Access is possibly a good option but I don't really understand what you need.
July 30, 2011 at 10:31 pm
Viewing 15 posts - 4,156 through 4,170 (of 18,926 total)