Posts
Sort by recent activity
Restores failing with exit code 790
I can't do a restore that includes full/diff/logs. I get sql error 3136 This differential cannot be restored because the database has not been restored to the correct earlier state. This happene...
Restoring from a network share
PLEASE, make this work. I've been using sql backup for a lot of years and this is a MAJOR PITA. All I want to do is go to a file share and pick a backup to restore. Why do I have to go to the sh...
For Pete's sake already. DBCC TRACEON/TRACEOFF 3604
I know that this has been brought up before, but it sure would be nice if my log file didn't have tens of thousands of theses informational messages. :x :evil:
Seriously, could someone acknowledge...
RESTORE LATEST_ALL never starts
I'm trying to script a restore job using the LATEST_ALL option and it never starts and I don't receive any errors. It's currently been running for 20 minutes and it's a very small database (about ...
Upgrading server components from UI fails
I get errors and have to manually install on 30+ servers. It never has worked for me.
sv0220sqlmon1\dba: Server Component Installation - Failed
====================================================...
Strange restore issue
I've been having problems restoring differential backups. One database I tried last week gave me SQL errors 3013 and 3136 and the restore left the DB in recovery state. Then one I just tried now ...
GUI bug
This is going to be difficult to explain but here goes. I'm doing a point in time restore so there is 1 full, 1 diff, and several log backups that I select from a directory. When I go to the next...
Connection Options
Is there a way to force SQL Prompt to use the connection account that I specify in the options? I want to be able to use an sa account in there so developers can decrypt procedures without having ...
Comparing encrypted procedures
What permissions are required for comparing encrypted procedures? I have a developer role that is a member of db_datareader,db_datawriter,db_ddladmin and db_securityadmin. They are comparing a sc...
Can't restore at all now.
I just did a full backup on a database and tried to restore it to a new database. It will not work. It just sits a 0 bytes processed. There's no bar in the timeline. No error messages.