Viewing 15 posts - 3,451 through 3,465 (of 6,216 total)
Quick fix would be to use the mdf you restored on the other server, detach/copy/attach.
Andy
August 18, 2002 at 7:55 pm
It's not a bad idea to put the log files on a separate RAID set for two reasons, one is that log files tend to be sequential access and so...
August 18, 2002 at 2:33 pm
It should be pretty much self maintaining. It will see quite a bit of activity, both in the mdf and in the log files. I typically let mine grow until...
August 16, 2002 at 3:32 pm
I agree that they should be ignored, but I believe they are maintained by updating your statistics, whether you have set to happen automatically or do it via a job....
August 16, 2002 at 3:05 pm
And it would be nice to see what you've attempted in TSQL even if it doesnt work.
Andy
August 16, 2002 at 4:46 am
No idea. I'll try to experiment this weekend if no one solves it, though I dont have SQL7 installed, SQL2K only.
Andy
August 16, 2002 at 4:45 am
If you put just the primary key into your table you'd just have to join back to get the other details. Would be interesting to see if it made much...
August 16, 2002 at 4:44 am
What do you have indexed? Where is the clustered index? You could optimize some by creating a permanent table and just truncating it each time. Not sure how good 'not...
August 15, 2002 at 8:02 pm
How long is the backup taking? Box heavily loaded? No chance its a bug in your code (just asking!)? Db should not block connections because of a log backup, have...
August 15, 2002 at 7:59 pm
With the version we have, not being an asp guru by any means, doesnt look fun. Probably not as bad as it looks. Have to think that if you can...
August 15, 2002 at 4:41 pm
Once you restore, you're trying to connect as SA or using NT login?
Andy
August 15, 2002 at 4:39 pm
It'll still be sp_start_job, just open a connection and execute, or you can use DMO to do it.
Andy
August 15, 2002 at 4:37 pm
I think you can use the /3GB to make 3G available, of which SQL can use a max of 2, leaving 1g for other stuff.
Andy
August 15, 2002 at 10:41 am
Cant think of a better way. Doesnt mean there isnt one!
Andy
August 15, 2002 at 10:41 am
I think you'd have to get the data into a variable first.
Andy
August 15, 2002 at 7:33 am
Viewing 15 posts - 3,451 through 3,465 (of 6,216 total)