Viewing 15 posts - 5,311 through 5,325 (of 9,241 total)
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
laddu4700 (7/14/2012)
User db full backup job failed with below error. Anybody encountered this error. please let me know.
Message
Executed as user: domain\adsi. Microsoft (R) SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2012 at 5:37 am
GilaMonster (7/14/2012)
Welsh Corgi (7/14/2012)
When you say for the second do you mean that I would need a 3rd party tool for the SSIS Transfer of Data?
As I said, SQL column...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2012 at 5:33 am
JJ-469859 (7/14/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2012 at 10:58 am
Viewing 15 posts - 5,311 through 5,325 (of 9,241 total)