Viewing 15 posts - 8,476 through 8,490 (of 9,244 total)
check the onepoint database recovery model as suggested already
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2009 at 12:51 pm
your welcome Jason
as we have stressed already, just make sure resource is i the same place as master.mdf otherwise when you come to upgrade you could\will hit problems
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2009 at 12:46 pm
IIRC the only time you get problems with upgrades after moving the master database is if the resource database is in a different location. That is why they need to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2009 at 11:24 am
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
Viewing 15 posts - 8,476 through 8,490 (of 9,244 total)