Activity overview
Latest activity by keymoo
Possible to have a bulk option?
SQL Data Compare uses INSERT statements to sychronize databases - is it possible to use a bulk option where the data is bulk exported to native files and then bulk loaded into the destination?
Cannot restore SQL Error Code:5133
Hi there,
I'm trying to restore a database and I get this output from the GUI:TPFADBMOPS04\MIPFAPSQLFA01: Restore - Failed
============================================
Restoring full backup - Fail...
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.
Error in event log - Query status of service
Hi there,
My SQLBackupAgent is not running as a local admin and I want to keep it that way. How can I grant the correct permissions to correct the error below?
Event Type: Failure Audit
Event Sourc...
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?
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.
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...
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...
VDI error 1000: Failed to recognize the SQL Server instance
Hi there,
I have a SQL Server 2000 SP3 machine running on Windows 2000 Server SP4. I get the following errors in the SQL Backup log:SQL Backup log file 5.3.0.178
-SQL "BACKUP LOGS EXCLUDE 'master,...
try reading this http://www.catb.org/~esr/faqs/smart-questions.html / comments
try reading thishttp://www.catb.org/~esr/faqs/smart-questions.html