Posts
Sort by recent activity
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...
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...
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,...
SQLAgent account longer than 30 chars
Hello,
I am getting the symptoms described in this article:http://www.red-gate.com/supportcenter/C ... 000285.htm
However, the article does not describe exactly what security checks are skipped whe...
Change log file location
Hi there,
I want to change the log file location of my server components. How do I do that?
Thanks
Why are you recommending backing up to local disk first?
Hi,
Just upgraded to 5.3.
I have set up SQL Backup to backup to a network share as I don't have space on my local server. I do notice however, that you have a warning in the client GUI to backup fi...
SQL Refactor, SQL Prompt greyed out
Hi there,
My SQL Refactor and SQL Prompt menus are greyed out in SSMS - I haven't used it in a while and wanted to use it again. I have the SQL Prompt icon in my systray and it is enabled. I close...
Aggregates showing up as different when they're not
Hi there,
Using SQL Compare 6.2.0.271
I am comparing a database to a folder of scripts. I have done a synchronization, and when I redo the synch everything looks the same except my aggregate functi...
Automating SQL ChangeSet
Hi there,
I am using SQL ChangeSet with SQL Compare 6 to manually Compare our development database against the latest source from Visual Source Safe. I'd like to be able to:
1) Automate the changes...