Viewing 15 posts - 36,751 through 36,765 (of 39,944 total)
I think this will cause an issue. Can you not take a full backup and move that over after the new file?
Steve Jones
February 7, 2003 at 9:38 am
If they rarely change, I'd put them in each db and then use an app, script, or possible replication to update them.
If they change often, I'd probably use a master...
February 7, 2003 at 9:31 am
Probably that's it. Covers two drives failing before the spare gets going.
If you get it for no $$, might as well. Buy 5-8 drives for your main array, 2 more...
February 6, 2003 at 5:46 pm
Still won't protect the code from someone getting to it. Anything can be decompiled.
Steve Jones
February 6, 2003 at 5:42 pm
not sure what you mean? are you replying to the article or a post?
Steve Jones
February 6, 2003 at 5:39 pm
And intellisense!!!!!
Send suggestions to sqlwish@microsoft.com
Steve Jones
February 6, 2003 at 2:14 pm
Depends on the performance. I'd simulate the 10M rows and see, but my thought is one table/month. If the db performance is too low, separate DBs or even filegroups can...
February 6, 2003 at 2:03 pm
Like Raid 5 +.
Here's the FAQ:http://h18004.www1.hp.com/products/servers/proliantstorage/arraycontrollers/adg/questionanswer.html
Looks like the space usage for parity is 2 drives and is worth it above 5 drives. Basically appears to be items.
1. Allows 2 drives...
February 6, 2003 at 2:00 pm
Pause does that. Let's everyone finish, no new connections. I think in your job, if it makes one connection, could pause the server, kill connections in the db, run the...
February 6, 2003 at 11:08 am
Possible tape issue. Have you changed tapes? Can you manually run a backup? Perhaps out of space on the tape?
This is the OS reporting and error. I never backup straight...
February 6, 2003 at 11:06 am
Do you have other databases on this server? If not, you can "pause" the server
Steve Jones
February 6, 2003 at 10:59 am
You'd have to use sp_oaCreate to create an ActiveX object. You could use the MS HTTP control and then have it execute the ASP page.
Steve Jones
February 6, 2003 at 10:57 am
Write a stored procedure to delete these.
something liek
delete x
where x.datetimefield < dateadd( y, -1, getdate())
Then schedule this to run every day or week, depending on what you need.
Steve Jones
February 6, 2003 at 10:46 am
Wow. Not sure I've seen a worse one. Granting rights to public is BAAAAADDDDDD!
Steve Jones
February 6, 2003 at 10:15 am
not sure what you mean? If you are in mixed mode, the "sa" account can log in. What do you mean "startup account". The SQL Service account?
Steve Jones
February 6, 2003 at 10:12 am
Viewing 15 posts - 36,751 through 36,765 (of 39,944 total)