Viewing 15 posts - 391 through 405 (of 410 total)
You mentioned that there is no free space in the log so you apparently already did a logspace on it. Try this:
BACKUP LOG TO DISK = '\\computer\share\mylog.trn'
Jim
February 27, 2011 at 8:25 pm
Trying to connect? You mean from SSMS, choosing Connect and then Database Engine and specifying the R2 engine running some where? I can't imagine this is the case...
February 27, 2011 at 7:57 pm
No problem. Glad to help.
The 1% comment was just an example. I was alluding to ensuring that your log file was mighty large - much larger than you think...
February 27, 2011 at 9:40 am
What we are saying is to almost never shrink them. Until the tlog is backed up (which marks the entries as 'available to be reused/overwritten'), it will constantly need more...
February 26, 2011 at 1:38 pm
fenwicc - ya, you are right. I was just saying that a 50 disk set is better than a simple 4 disk RAID 10 set because the load will...
February 25, 2011 at 10:07 am
Ha! You have to beg too? I have a client which is a large health care company who has extensive procedures for changing anything. <sigh>.
Even if you...
February 25, 2011 at 8:25 am
Ya, I kinda figured it was a problem requiring a recycle and not standard behavior with a monster query. Bummer.
Jim
February 25, 2011 at 8:02 am
Haha. You are funny.
One advantage is separate LUNs will allow for more control to tune which hot indexes go on specific isolated disk sets. With one giant set,...
February 25, 2011 at 7:56 am
Parallelism can indeed cause CPU blocking; so SS won't schedule another task on a CPU which is waiting to sync with the other CPUs. meanwhile, that CPU is at 0%....
February 25, 2011 at 7:53 am
I saw you were using with move. I was just noting to cross examine the disk space requirements one more time.
Have you tried to create a simple db on...
February 25, 2011 at 7:26 am
Sounds more like a disk space issue.
Restoring the data files will create them at the same size as they were when they were when backed up - including empty...
February 25, 2011 at 12:20 am
Why fear the FileGroup? It may be best to emptyfile the 25GB files and make a new file group, each at 75G on f, g & h. Then assign...
February 25, 2011 at 12:11 am
Awesome article Gail; very clear.
Anirev - in short, you MUST backup the log in order for SS to mark the huge amount of log entries as 'available to be overwritten'....
February 24, 2011 at 11:47 pm
Glad to help.
Please do post the results here so we get a nice googlable thread with an answer.
Jim
February 24, 2011 at 12:49 pm
Wow. After 13 hours, the kill status is still at 0%? Either the statement was running for a very long time with tons of data updates BEFORE it was...
February 24, 2011 at 12:45 pm
Viewing 15 posts - 391 through 405 (of 410 total)