Viewing 15 posts - 3,781 through 3,795 (of 6,216 total)
You can do it with DTS. No matter how you do it it will take some work. I'd suggest if you can trying to do it in batches of a...
July 15, 2002 at 7:49 am
DMO tries to be all things to all people. You lose some speed in exchange for versatility. Nothing wrong with that, but definitely there are times when it will be...
July 15, 2002 at 6:47 am
Sounds bad! Tried restarting it I imagine? Maybe the file was corrupted, I'd suggest trying a reboot if you can, maybe replacing the logreader.exe from another box running same service...
July 15, 2002 at 6:45 am
The same rules apply for changing recovery mode on msdb as on any other db. My guess on the msdb is that there is rarely a need to do a...
July 15, 2002 at 6:16 am
If you have a backup, you can just restore the entire db. Or you might have a script of the table in SourceSafe maybe.
Andy
July 15, 2002 at 4:37 am
That's a good point! Wish I woulda said it! Ah well. Anyway, I agree with Steve that triggers do a good job of capturing data changes and are pretty easy...
July 13, 2002 at 5:38 pm
Keep in mind that the final query plan is built based on all indexes. Hopefully you have one or more other indexes that will refine the rows, then you can...
July 13, 2002 at 5:57 am
Yes, that technique works well. If you just want a "normal" db you can reinstall and then just attach it. For master and msdb, the method described works well.
Andy
July 12, 2002 at 4:39 pm
I agree on that one - doing a select first is a very sound principal!
Andy
July 12, 2002 at 4:37 pm
Typically once an error occurs the proc will end. I prefer to write as little error handling as possible, instead coding aggressively to identify problems as they happen and degrade/react...
July 12, 2002 at 8:23 am
July 12, 2002 at 8:18 am
No sweat, as long as you try we dont mind helping you find the answers if we can.
It'll branch to whatever error handler is active. Typically you might have code...
July 12, 2002 at 7:43 am
Or you can just detach/copy/attach on the other server, though then you have to adjust the logins yourself - CDW does part of it.
Andy
July 12, 2002 at 7:32 am
I'll go first..no laughing if Im wrong. Now maybe I should create the tables and see!
4!
Andy
July 12, 2002 at 7:30 am
If my math is right that works out to about 5 hours. Doesnt seem totally unreasonable, especially since you're running it small enough batches that it won't lock the entire...
July 12, 2002 at 5:55 am
Viewing 15 posts - 3,781 through 3,795 (of 6,216 total)