Viewing 15 posts - 46 through 60 (of 75 total)
GilaMonster (10/3/2013)
Have a look at the sys.dm_os_memory* DMVs and the memory-related counters for SQL Server in perfmon.
Hi gila thanks for your reply
now i wanted to know whether i can...
October 4, 2013 at 10:01 pm
GilaMonster (9/26/2013)
anoop.mig29 (9/25/2013)
but where are this log files kept
Where ever you choose to put the log backups that you take. Mirroring doesn't use log backups, so where they go is...
September 28, 2013 at 2:22 am
MyDoggieJessie (3/1/2012)
I don't believe there is a way to access/schedule the SSRS report that's built in to...
September 27, 2013 at 1:08 am
GilaMonster (9/25/2013)
anoop.mig29 (9/25/2013)
how is this carried out in mirroring , i mean where are this log files and how are they shipped
Automatically. In mirroring the log records are sent across...
September 25, 2013 at 10:42 pm
lshanahan (9/25/2013)
You also want to check your anti-virus software and firewalls and be sure DatabaseMail is permitted.
Carlaabanes (9/24/2013)
September 25, 2013 at 11:57 am
GilaMonster (9/3/2013)
As for why SQL's using the memory, because it can. Because it has not been told that it can't (via max server memory)....
September 4, 2013 at 3:21 am
GilaMonster (9/2/2013)
Chapter 4: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/Set max server memory to a sensible value.
hi gail thanks for link but can u more specific
I would download the book an study it but can you...
September 2, 2013 at 11:34 pm
GilaMonster (8/24/2013)
anoop.mig29 (8/24/2013)
@Gail problem is there are 2 dr of a single primary and only is participating in DR drill so i cannot stop ls backup job at primary.
I never...
August 26, 2013 at 10:54 pm
GilaMonster (8/23/2013)
Full backups DO NOT break the log chain.
Therefore, to re-initialise the secondary after the drill, take a full backup of the primary, copy it, restore it,...
August 24, 2013 at 1:04 am
HanShi (8/23/2013)
I think "anoop.mig29" means (correct me if I'm wrong):
Restore f1 as a logshipping target and then restore t1 and t2 with the logshipping process. Then manually restore f2...
August 23, 2013 at 10:33 am
GilaMonster (8/23/2013)
August 23, 2013 at 6:26 am
Lynn Pettis (8/23/2013)
anoop.mig29 (8/23/2013)
GilaMonster (8/11/2013)
anoop.mig29 (8/10/2013)
But suppose before T3 i take full backup F2 then i cannot restore T3 untill F2 is restored.
Sure you can. Full backups do not in...
August 23, 2013 at 5:55 am
GilaMonster (8/11/2013)
anoop.mig29 (8/10/2013)
But suppose before T3 i take full backup F2 then i cannot restore T3 untill F2 is restored.
Sure you can. Full backups do not in any way interfere...
August 23, 2013 at 4:21 am
raadee (8/22/2013)
The 10 is the target size, so you would end up with a transaction log that is 10MB.
So u mean when i specify
dbcc shrinfile(2,10)
it tryies to reduce log...
August 22, 2013 at 11:41 pm
HanShi (8/22/2013)
You mention the LOG backups are created correctly. Are the LOG backup files being copied correctly?...
August 22, 2013 at 11:36 pm
Viewing 15 posts - 46 through 60 (of 75 total)