Viewing 15 posts - 2,326 through 2,340 (of 2,435 total)
March 11, 2005 at 2:10 pm
More questions than answers for starters:
10k or 15 K disks ? what size ? smart array disk controllers or the builtin ? if smart array controllers, how much memory ?...
March 11, 2005 at 2:07 pm
March 11, 2005 at 8:04 am
Here's the link that you'll need:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k
March 10, 2005 at 9:10 am
get the database into 'single user mode' and runn a couple of DBCC commands. My guess is that DBCC CHECKDB will be clean. I'd try the following:
DBCC CHECKALLOC ( 'database_name' , REPAIR_REBUILD ...
March 9, 2005 at 11:57 am
Good transaction log maintenance means consistent transaction log size and consistent transaction log backups in my book (this assumes a stable and well written application, whether 'home-grown or from a...
March 9, 2005 at 11:51 am
Be careful though, the prompt is in 'English' so to speak ... so be sure to jot down the 'sort order' and 'character set' from sp_helpsort.
March 9, 2005 at 10:25 am
The 'sort order' and/or 'character set' are different on the servers (in SQL v7.0 and SQL2000 they are collectively referred to as 'collations').
Try executing sp_helpsort on both servers. It will...
March 9, 2005 at 9:55 am
Vitria is another to potentially look at.
March 9, 2005 at 8:49 am
A few things I have learned in my 'database travels in Sybase/Unix land':
1) Get on very friendly terms with your Unix System Administrator.
2) Pick up the O'Reilly book on 'ksh'...
March 8, 2005 at 9:21 am
Books Online should be installed on your v6.5 server.
March 8, 2005 at 9:09 am
'attaching' the files will onyl work if they (the databases) had been first 'detached'.
March 8, 2005 at 9:02 am
Aer there amy messages in the SQL Server errorlog ? Have you checked the System, Security and Application event logs ?
March 8, 2005 at 8:56 am
check out my post in this thread.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=165575
March 4, 2005 at 9:28 am
I had encountered this problem sporadically on one server backing up to a SAN disk. Check your transaction log maintenance plan to see if the "Verify the integrity of the...
March 4, 2005 at 9:26 am
Viewing 15 posts - 2,326 through 2,340 (of 2,435 total)