Viewing 15 posts - 5,311 through 5,325 (of 9,244 total)
sqlnaive (7/17/2012)
Does rebuilding the performance counters affect the SQL databases ? Should thee be some kind of tests done post rebuld ?
It will require a reboot so plan for that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 9:01 am
Damian-167372 (7/11/2012)
i was thinking to completely un-install the sql instance and not to remove the node from the cluster
no, just run setup and remove the node (which uninstalls just...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 3:57 am
lawson2305 (7/16/2012)
I run a tran backup and shrink every day. I append the backup daily except...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 1:10 pm
check the windows application log, there must be something in there.
Try starting the service manually and check the app log to
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 1:02 pm
JJ-469859 (7/16/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 11:10 am
Perry Whittle (7/13/2012)
What information do you require?
??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 9:16 am
ananda.murugesan (7/16/2012)
With 650 GB database size run these two commands, should take more time to finish. how to reduce the time during completion of these two commands.
Short of deleting all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 7:01 am
did you actually instal SQL Server 2008 database engine or just client tools, without knowing the options you selected its impossible to say, doesn't look like 2008 instance is installed.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 5:47 am
You understand this?
Perry Whittle (7/16/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 5:38 am
Shabnam Gupta (5/17/2012)
so you have to open the master key to create a certificate?
What does the following query return?
select name, is_master_key_encrypted_by_server from sys.databases
where database_id = 1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 5:03 am
forumlogger (7/16/2012)
Whats better..Uninstall 2008 and start again
or
Can I create a new instance for 2008 ?
Thanks
Open up services.msc and check what you have listed for SQL Server services. Post a screen...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 4:57 am
forumlogger (7/16/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 4:44 am
ananda.murugesan (7/14/2012)
old verision
OS -win 2003 enterprise edition
DB -SQL Server 2000 enterprise edition with sp4
DB Size - 650GB
New version
OS -win 2008 R2 enterprise edition
DB -SQL Server 2008 R2 enterprise edition with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 3:06 am
As vikrantspatil has pointed out you need to ensure beforehand that application compatibility is suitable for SQL server 2008 R2.
The other action i would perform first is to take a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 3:04 am
selectname AS JobName
, SUSER_SNAME(owner_sid) AS JobOwner
from msdb.dbo.sysjobs
or you could join msdb.dbo.sysjobs to master.sys.server_principals like so
SELECTj.name AS JobName
, sp.name AS JobOwner
FROM msdb.dbo.sysjobs j INNER JOIN
master.sys.server_principals sp ON j.owner_sid = sp.principal_id
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2012 at 2:03 pm
Viewing 15 posts - 5,311 through 5,325 (of 9,244 total)