Viewing 15 posts - 2,821 through 2,835 (of 2,903 total)
I admin two MSSQL Server 2000 database systems that are 24x7 mission critical. We have a Dell 136T tape library with 24 tapes on one and a HP Superstore DLT...
January 17, 2003 at 12:01 pm
Bkelly is correct....I was working with Veritas' Backup Exec when I responded to your posting. Backup Exec requires two licenses for a 2-node cluster. SQL Server only requires one license....
January 17, 2003 at 6:08 am
Been there, tried it, both ways even (NO RECOVERY to RECOVERY, RECOVERY to NO RECOVERY) and neither can be done. Once you set the recovery method that's what you are...
January 16, 2003 at 1:21 pm
You don't need to install SQL virtual server on each node! You install it on the shared disk. We have an active/passive cluster with a shared array. We loaded SQL...
January 16, 2003 at 1:18 pm
Thanks everyone for the information. I just found (via BOL) that I can't set my MSSQL service to run as anything but Administrator. Per BOL, when creating or maintaining MS...
January 13, 2003 at 12:06 pm
Steve,
I'm on MSSQL 2000 and my EM has xp_runwebtask, xp_makewebtask, and xp_dropwebtask. Doing a Google search on xp_runwebtask brings back several pages of vulnerability reports. This xp has an 'escalate...
January 13, 2003 at 10:59 am
I just ran a script that copied 300,000+ rows into a temp database, got the getdate(), counted all the rows (count(*)), then got the getdate(). The query took several seconds,...
January 10, 2003 at 12:37 pm
I think that in most cases it would be equal. But I believe it would be determined by how long the query takes (ie. if the second getdate() occurs more...
January 10, 2003 at 12:30 pm
Antares,
He didn't make a mistake. However, it would have been clearer if he had explained what the jobs were....let's say he's doing backups. Once a month (the 1st Sunday) he...
January 10, 2003 at 12:25 pm
Check out the stored procedure sp_spaceused in the Books OnLine. I think it will give you the information you want.
_SQLBill
January 9, 2003 at 1:29 pm
I get a similar error on one of my remote machines. Apparently, if you are on a separate domain your remote Enterprise Manager might not be able to see the...
January 8, 2003 at 6:28 am
SaNaz,
No matter how you do it, it's looking for a second tape IMMEDIATELY. It's not going to wait for you to put one in. The only solutions, when you need...
January 7, 2003 at 6:06 am
I agree with Steve, #1 is the better solution. Why make it harder than it has to be? Also, if something changes down the road, with #1 it's easier to...
January 6, 2003 at 10:29 am
What about the possibility of correcting typos and making it an ebook? It could be in .pdf format and we could purchase it and download it to our computer. Then...
January 6, 2003 at 7:32 am
I think it's a great idea! I would probably buy the book. One thing to check on with copywrites is ... are you making a profit on this book? I...
January 6, 2003 at 6:08 am
Viewing 15 posts - 2,821 through 2,835 (of 2,903 total)