Viewing 15 posts - 4,291 through 4,305 (of 4,745 total)
I only answered this so I could jump a month into the future and thus be on holiday.
July 16, 2008 at 5:17 am
you do not HAVE to check this box for log shipping to work.
July 16, 2008 at 5:06 am
as steve said, check with the users how 'real time' the data actually needs to be for reporting.
If real time go for replication, if not go for mirroring with snapshots....
July 16, 2008 at 5:03 am
check the logshipping tables in msdb, should give you more of a clue as to why it failed
July 15, 2008 at 4:49 pm
good news for info fix is to register msxml 6 (what that?)
To register MSXML 6.0.
1. From the Start menu, click Run.
2. Enter the following command:. regsvr32 %windir%\system32\msxml6.dll.
3....
July 15, 2008 at 5:17 am
oops, its 2005 so it wouldn't return 2273 would it....:blush:
if its still 3054 hotfix definitely not applied.
From the errorlog it was unable to delete file because:
The process cannot access...
July 14, 2008 at 3:48 pm
as long as you completely stop replication, you can safely backup db and restore it to a new location (on the same server) if that is what you want to...
July 14, 2008 at 3:33 pm
I am told there is a third party prouct called textpad which can 'tail' the erorlog and Microsoft has a log file reader that's currently free. It's on their...
July 13, 2008 at 12:17 pm
can I refer you to this article:
July 12, 2008 at 4:02 pm
you don't need to detach\attach the database to shrink it.
you can backup and restore the database without affecting replication as long as replication is quiesced (stop all the replication agents)
July 12, 2008 at 3:18 pm
with snapshots you are never going to get real time reporting, only NEAR real time. Recreating the snapshot every 5 mins seems excessively frequent.
Maintaining a snapshot is an overhead as...
July 12, 2008 at 10:59 am
then you would just have to do it manually by bringing secondary database online
either
restore database dbname with recovery
or
restore any outstanding tran logs and use the with recovery clause for...
July 12, 2008 at 7:02 am
Jayakumar Krishnan (7/11/2008)
yes, Add the stats clause in the RESTORE command and check the DBCC OUTPUTBUFFER(spid) of the specific restore spid, you can see the percentage of completion.
top tip
July 12, 2008 at 6:50 am
transaction log restores will also cause this proccache clear down, so if you are log shipping this will happen at regular intervals.
If this irritates you as it doe me ,...
July 12, 2008 at 6:41 am
apply whichever rollup brings it to 3068 to the client?
July 11, 2008 at 8:16 am
Viewing 15 posts - 4,291 through 4,305 (of 4,745 total)