Viewing 15 posts - 106 through 120 (of 306 total)
Okay no help from MS yet, let me run this across all you all.
If I open up cmd.exe and run "c:\mypath\logread.exe" -publisher [mypubsvr] -publisherDB [mypubdb] -Distributor [myDist] -DistributorSecurityMode 1 -Continuous...
July 7, 2003 at 2:59 pm
Here's a lousy workaround I'll send it back to step one when it fails. The only negative (maybe) it'll never die when and if there's a true failure on the...
July 3, 2003 at 10:46 am
I agree, that's the dang thing. Yep log reader is set continous.
Here's the kicker this is an Active/Active cluster seperately it fails it looks like when there is nothing to...
July 3, 2003 at 10:26 am
Andy here's a copy of it when it works, albiet the pub and the distr are now on the same server
Microsoft SQL Server Log...
July 3, 2003 at 8:14 am
Hi Andy
Here's a copy of the replinfo.txt when the job fails.
Microsoft SQL Server Log Reader Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL...
July 3, 2003 at 8:04 am
Dang it failed again, just pull the carpet out from under my feet!
John Zacharkan
July 2, 2003 at 11:50 am
Might have found the answer, would appreciate any feedback though. On the Repl-LogReader job agent step 2 run agent under advance retry attempts I change this to 10 to mirror...
July 2, 2003 at 11:46 am
Try copying the backup down to disk first and then restoring the database.
John Zacharkan
June 30, 2003 at 9:43 am
In my experience the effect should be a positive, opening and closing takes up
resources. Unless of course you don't have the resources to have all the databases open in...
June 25, 2003 at 9:45 am
Detach and attach hands down is the fastest way. The only question is can you take your database offline?
If you have the room make a copy of it on...
June 25, 2003 at 8:41 am
Yes you can make transaction log backups and do Log Shipping.
Log Shipping is what you do with all those transaction log backups. As long as the Log Shipped database...
June 25, 2003 at 8:29 am
Dear eljeffo,
Thank you for your offer letter. I accept for the agreed 115K plus travel and relocation expenses.
I cannot however put up with anyone getting angry so the terms...
June 16, 2003 at 8:46 am
I'm a SQL server DBA and I have a brother that lives in Chiemsee, does that count.
Cheers
John Zacharkan
June 16, 2003 at 7:37 am
Kill a long running transaction and while it's rolling back out pull the plug on the server. That's what one of my former clients did. (they didn't have a...
June 12, 2003 at 11:55 am
sp_tableoption 'tablename',@OptionName ='pintable'
John Zacharkan
June 11, 2003 at 1:02 pm
Viewing 15 posts - 106 through 120 (of 306 total)