Viewing 15 posts - 36,706 through 36,720 (of 39,903 total)
Agree with the last post on that one. Better to setup a backup job. depending on AutoClose isn't a reliable option.
Steve Jones
February 10, 2003 at 9:47 am
dual doesn't work in SQL Server.
select 'pick a schema', ''
union
select col1, col2 from my_table
Steve Jones
February 7, 2003 at 3:03 pm
Never used the $99 option. In my last job, I used the $250 option, one was a bug, no charge, one was help fixing corruption.
At this job, we're a Premier...
February 7, 2003 at 3:01 pm
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
Viewing 15 posts - 36,706 through 36,720 (of 39,903 total)