Viewing 15 posts - 8,476 through 8,490 (of 9,241 total)
its in BOL but here goes
open sql configuration manager and modify the startup parameters for that sql instance. The paramaters will look something like this
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2009 at 11:11 am
up to you entirely really, tempdb is the one you should ideally relocate. Bear in mind if you do move master, where ever you put master.mdf the mssqlsystemresource.mdf and ldf...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2009 at 4:00 am
dude i dont know what you're smoking but i'd sure like some LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2009 at 3:46 am
dude madhu
BOL makes some assumptions here. Generally rebuild is used for corrupt installations of sql server and the restore of the system databases is standard routine, even then you may...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2009 at 3:34 am
the following can be used to generate the scripts to grant execute on all SP's in a database if required
select 'grant execute on ' + s.name + '.' + o.name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2009 at 4:46 pm
am i right in thinking you have rebuilt the system databases to a different collation but then trying to restore the original databases with the original collation?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2009 at 4:12 pm
madhu
what is the geographical location of your sql server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2009 at 4:10 pm
feel the force Luke LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2009 at 3:57 pm
as Gail pointed out remember that to make the passive node active would require a new set of disk resources for the 2nd active instance. Is it worth the trouble,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2009 at 3:54 pm
Bear in mind that you will only be able to implement a 2 node cluster due to the limitations of virtual SCSI adapters. Clustering requires windows 2003 Enterprise OS. For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2009 at 3:51 pm
Jason try
select name, state, state_desc from sys.databases where state = 6
will show offline databases. Or check for
where state_desc = 'OFFLINE'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2009 at 3:42 pm
did you try opening computer management console from your machine to remote server and viewing the services? My guess is this will fail. What permissions does your windows account have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2009 at 6:27 am
Jeff Moden (1/14/2009)
you floor a 4 week drive on black ice on a curve, all wheels loose traction at the same time.
that's neat. On the flip side, due to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2009 at 4:42 pm
yes, post installation just creates the windows service and licences it before creating the objects, but under 9.2 the SDE is part of the application server suite, even under 9.1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2009 at 4:36 pm
sblock (1/27/2009)
ArcSDE is installed on the same server as the Sql Server.
in an ideal world no. In v9.2 SDE is part of the ArcGIS server suite and the SDE libraries...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2009 at 11:38 am
Viewing 15 posts - 8,476 through 8,490 (of 9,241 total)