Viewing 15 posts - 9,091 through 9,105 (of 9,244 total)
yes very important make sure you keep a copy of the enterprise system databases incase you need to bring them back online otherwise you'll need the install cd to repair...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 1:11 pm
Jeffrey Williams (7/28/2008)
I am going to side with both Gail and Perry here
not to mention the tone with which the words echoed to whom i would class as a well...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 1:04 pm
gunna48 (7/28/2008)
sp_dropserver '[YourOldDatabaseName]'--Present Server name goes here
go
sp_addserver '[YourNewDatabaseName]','local'--New Server name goes here ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 12:58 pm
jim.powers (7/28/2008)
If that switch is not already there, it does need to be added.
on the very rare odd occasion and normally for older processor architecture. 99% of the time the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 12:53 pm
george sibbald (7/28/2008)
what Perry and Terry (great name for a double act)
not a s good as Kevin and Perry,, yes mrs patterson 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 7:02 am
are we talking 1 instance of sql server??
what are min and max memory set to on instance properties?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:34 am
on SQL2005 queries that try to update the system catalogs will be rejected anyway 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:32 am
Milton Gonsalves (7/25/2008)
So only Enabling /PAE should also help.., right?
if your using win 2003 enterprise it should address all the RAM straight off without editing the boot.ini
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:30 am
alimcitp (7/28/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:21 am
ensure you configure the "lock pages in memory" local security policy for the account SQL runs under. Generally its not recommended to use the /3GB switch for machines with 16GB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2008 at 10:01 am
just found the MS kb article, it seems 32 bit SQL2005 std can lock pages its just the 64bit that is an issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 24, 2008 at 9:31 am
to specify locations for user databases go into SSMS and right click the registered\connected SQL instance and select properties.
Under database settings you specify the default folder for data files and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 3:37 pm
this is the MS description
this explains it too
http://technet.microsoft.com/en-us/library/ms190730.aspx
basically without it set memory can be paged to disk which will cause huge problems for the running SQL instance. Its important to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 3:31 pm
clustering is a windows server feature and not windows xp. However, using Microsoft VirtualServer you can on a laptop that is powerful enough set up a virtual 2 node MSCS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 3:13 pm
using terminal services in application mode would ideal for remote users, the processing is all done on the terminal server which would be on the same LAN as the database....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 3:09 pm
Viewing 15 posts - 9,091 through 9,105 (of 9,244 total)