Viewing 15 posts - 151 through 165 (of 388 total)
Did you keep a copy of the original files, if so you can issue the alter command again and point back to the older files, I have a feeling that...
May 20, 2008 at 11:46 am
did you apply a service pack before or after doing this, I know I have seen the ldf file for this base be recreated during a patch if it is...
May 20, 2008 at 11:07 am
The Ip will not be the issue, clustering uses virtual ips so you can multipe instances running on one physical node, but you are not going to be able to...
May 2, 2008 at 12:36 pm
If you would consider yourself an experienced DBA, I would go for Professional SQL Server 2005 Administration
Brian Knight is one of the contributers and he wrote
SQL Server 2000 for Experienced...
February 22, 2008 at 3:36 pm
I run a job that uses master.dbo.xp_servicecontrol 'QueryState', 'SQLServerAgent'
go
master.dbo.xp_servicecontrol 'QueryState', 'MSSQLServer'
from a remote monitoring box, if I get a non running state the code inserts into a table and then...
February 22, 2008 at 3:29 pm
I am assuming you could have this in seconds, if so you could configure a SQL job to run and have that run N # of seconds to pick up...
February 22, 2008 at 3:19 pm
I believe that another vendor, IDERA SQLSAFE, does do this, we are using both products, legacy IDERA and LiteSpeed as defacto. I was on a call with IDERA yesterday and...
February 22, 2008 at 2:38 pm
The only problem with xp_msver is that it tells you how many processors SQL thinks there is, if you have hyperthreading it will count the logical processors. Maybe you pull...
January 10, 2008 at 10:56 am
I work in a mixed shop, one team on SQL Server and the other on Oracle, I am on the SQL side of the house. From all the moaning, support...
January 6, 2008 at 3:09 pm
As a quick test you could use the maxdop option in the query itself OPTION (MAXDOP 1) will use one processor, maybe the parelism is the culprit.
January 2, 2008 at 2:18 pm
Is any tape backup occuring?
September 9, 2007 at 8:01 pm
You can script this out, then paste into QA and run and see how this runs.
August 29, 2007 at 2:34 pm
Try select @@version it details (x64) 64 bit or (x86) 32 bit
August 28, 2007 at 10:20 am
Ronnie,
You can start the SQL instance with a couple of start up switches so only master comes up, you can then issue some commands to relocate the other system databases:...
August 27, 2007 at 10:16 am
Search 'Using Startup Options' in BOL, this describes what you need to do.
Andrew
August 25, 2007 at 11:15 am
Viewing 15 posts - 151 through 165 (of 388 total)