Viewing 15 posts - 8,551 through 8,565 (of 9,244 total)
option 1 is the native client update, option 2 is the full monty 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:36 pm
usually a repair of the .NET 2 framework is enough did you try that at all in your previous steps
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2009 at 10:28 am
madhu
your service account does not need domain or machine rights as they are automatically assigned by the setup program or sql config manager. A series of local groups get created...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2009 at 12:15 pm
releasing space can be wasteful of resources. Space in the file wil be required to carry out the action, so it'll only grow again and have you going round in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2009 at 11:53 am
Gail, who knows i'm with you on this!
BTW happy new year 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2008 at 8:13 am
Daksin
as Adi pointed out you cannot query the database in the norecovery state. Bear in mind with the standy option when log file restores occur users will be kicked out...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2008 at 8:11 am
GilaMonster (12/31/2008)
Full backup's not going to fix the problems the shrink caused,
Gail, i see where Paresh has gone with this. He advises that after truncating the log and breaking...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2008 at 8:02 am
Dugi (12/31/2008)
ps (12/31/2008)
we dont have double post. we've 5 posts on the same topic!!
Yes I can see for that reason I told Steve that the SSC board should have more...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2008 at 3:27 am
also remembering from another of your posts,
did you set the "lock pages in memory" policy on this server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:23 pm
BTW nice script Jeff
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:09 pm
dholland (12/30/2008)
Just checked:
Microsoft SQL Server Management Studio9.00.1399.00
That is SP1. My server is on SP2, let me...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:06 pm
DBADave (12/30/2008)
TREND - Anti-virus (not real-time)CSA - Cisco Security Agent
Double-Take - Replication to Disaster Recovery server
great, bound to be a few memory leak issues with that little lot installed.
you dont...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:00 pm
you need to size the log file appropriately to handle transactions between backups.
what is the recovery model of the database set to at the moment?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 1:08 pm
oh dear madhu you are in a pickle arent you.
what do you have min and max memory set to on node 1?
have you thought about setting up a sql trace...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 12:54 pm
what does the following query return on the server you are having problems on?
select @@servername
it sounds as though the sql instance cannot be verified and hence it thinks no service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 12:46 pm
Viewing 15 posts - 8,551 through 8,565 (of 9,244 total)