How can we help you today? How can we help you today?
keymoo
Activity overview Badges (0) Posts (10) Comments (15)

Comments

Sort by recent activity
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
  1. Community
  2. SQL Backup Previous Versions
  3. Feature Request - Restoring a database
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
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1000: Failed to recognize the SQL Server instance
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
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1000: Failed to recognize the SQL Server instance
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
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1000: Failed to recognize the SQL Server instance
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
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1000: Failed to recognize the SQL Server instance
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
Total activity
34
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
9