Viewing 15 posts - 46 through 60 (of 73 total)
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
Adi Cohn-120898 (7/22/2013)
July 22, 2013 at 12:43 pm
Hi every body Issue has been resolved what we did that we checked properties of providers.I that every properties where checked by some one.we unchecked all except "Allow Inprocess" specially...
May 23, 2013 at 7:19 pm
Viewing 15 posts - 46 through 60 (of 73 total)