Forum Replies Created
Viewing 15 posts - 36,586 through 36,600 (of 39,717 total)
-
RE: Number of DBs Supported
Is your dba a network engineer? Be careful here. Someone needs to sniff the network and provide evidence of being "too much work"
Also, what does that mean? Things are slow?
Doesn't...
-
RE: Another Disaster (Almost)
Glad I'm not Andy or the last guy
I've been pretty lucky with very few disasters, and hopefully that will continue.
Steve Jones
-
RE: New Hardware - Suggestions wanted
$50K is pretty good. How is this system used? Lots of transactions? More reads?
I'd go with RAID 10, try to separate out tempdb (if used) from other db and...
-
RE: SQL2K CLIENT
ODBC drivers will work. Get the latest MDAC from MS will work. You can also install the client tools from the SQL Server CD on W98.
Steve Jones
-
RE: Copy Database
There isn't an easy way to avoid the autoiuncrement fields. You'd need to script something for these.
To copy the database, a backup and restore is the easiest way.
Steve Jones
-
RE: Can't Shrink tempdb
Restart the server should bring it back down.
I assume you've right clicked in EM and done shrink. If not, do that.
Any errors in the logs? Might also try this shrink...
-
RE: T-log backup deletion in Maint Plan
Have you checked that the SQLAgent account has rights to delete? Check the log files for the maintenance plan for errors.
Steve Jones
-
RE: what is xp_runwebtask ???
This is a holdover from SQL v6.5 which takes a query and then builds an HTML page from the results. It isn't documented in v7 or 2000, but was left...
-
RE: Zero Length Log Backup
Are you appending to one file or making a new one each time?
Steve Jones
-
RE: TCP/IP default port
Sounds like you have some bug set. Perhaps SQL is setup for dynamic ports? Check the network setup. I restart SQL and have no issues on a number of servers.
Steve...
-
RE: How accurate is GETDATE()?
Intersting, have to check on this. Will try to ping some MS contacts to see if we can get an explanation of the coding.
Steve Jones
-
RE: Copy_table_schema
Personally I'd stick with a simple solution if I could.
backup/restore.
Script the deletion of all data.
Steve Jones
-
RE: Network-Attached Storage
Haven't used a NAS, though we have some on a SAN. Similar concept, slightly different architecture. The idea behind this is that the storage is consolidated and rarely, if ever,...
-
RE: RAID Questions
NO RAID 0. Not worth it on a production server. If one drive goes, your server is down. The tempdb should be on RAID 1 or 5 or 10, same...
Viewing 15 posts - 36,586 through 36,600 (of 39,717 total)