User profile for keymoo

Great suggestion Andrew - I back these suggestions 100%. It would be great if both features were implemented, I suspect the first one should be pretty easy to code up. / comments

Great suggestion Andrew - I back these suggestions 100%. It would be great if both features were implemented, I suspect the first one should be pretty easy to code up.

0 votes

Great that fixed it - however I really don't want to run the SQL Backup service as a local admin. red-gate: anything else for me to try? / comments

Great that fixed it - however I really don't want to run the SQL Backup service as a local admin. red-gate: anything else for me to try?

0 votes

brosato wrote: Just make it local admin and that will fix everything. Very funny - actually I did do that just as a test and I got identical behaviour. / comments

brosato wrote: Just make it local admin and that will fix everything. Very funny - actually I did do that just as a test and I got identical behaviour.

0 votes

Thanks Jason, when running sc sdshow "SqlBackupAgent" I get D:(A;;CCLCSWRPWPDTLOCRRC;;;SY)(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)(A;;CCLCSWLOCRRC;;;AU)(A;;CCLCSWRPWPDTLOCRRC;;;PU) To answer your other questions - There is only one default instance of SQL Server (2000 SP3) - The SQL Backup Agent is running as a domain account called sa-SQLBackup and is in sysadmin server role in SQL Server. It is a normal account on the server (i.e. not a local admin). / comments

Thanks Jason, when running sc sdshow "SqlBackupAgent" I get D:(A;;CCLCSWRPWPDTLOCRRC;;;SY)(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)(A;;CCLCSWLOCRRC;;;AU)(A;;CCLCSWRPWPDTLOCR...

0 votes

Just to add, I ran: sc sdshow "SQL Backup Agent" on the server and got this output: [SC] OpenService FAILED 1060: The specified service does not exist as an installed service. However when I run net start "SQL Backup Agent" I get: The requested service has already been started. More help is available by typing NET HELPMSG 2182. / comments

Just to add, I ran: sc sdshow "SQL Backup Agent" on the server and got this output: [SC] OpenService FAILED 1060: The specified service does not exist as an installed service. However wh...

0 votes

try reading this http://www.catb.org/~esr/faqs/smart-questions.html / comments

try reading thishttp://www.catb.org/~esr/faqs/smart-questions.html

0 votes

There are no keys named Red anything, no red-gate, redgate or red<space>gate. This is a production server so I need it fixed - should I call redgate support? / comments

There are no keys named Red anything, no red-gate, redgate or red<space>gate. This is a production server so I need it fixed - should I call redgate support?

0 votes

Brian, Yes that was it, thanks - I am using a 64-bit server. Working fine now. / comments

Brian, Yes that was it, thanks - I am using a 64-bit server. Working fine now.

0 votes

Thanks, on one of my servers where the SQL Backup server components are installed I am getting the above symptoms but the registry hive HKLM\SOFTWARE\Redgate does not exist. This means I cannot add the SkipChecks key to this server. Please advise as to how to fix this. Regards, keymoo / comments

Thanks, on one of my servers where the SQL Backup server components are installed I am getting the above symptoms but the registry hive HKLM\SOFTWARE\Redgate does not exist. This means I cannot add...

0 votes

Thanks Michelle, email sent. / comments

Thanks Michelle, email sent.

0 votes

How can we help you today?

keymoo

Comments