Search
-
Re: Error on restore of Transaction Log
For the log file that failed to restore, could you pls try using sqb2mtf to convert it, then restore it using the regular T-SQL RESTORE command? If you restore multiple log files, the log file does contain the individual log file names that were restored e.g. 5/5/2005 12:16:56 PM: Restoring transaction logs for database… -
Re: Multiple log shipping
>> I just want to backup database from the working server into this laptop (may be once or twice per day). I assume you are referring to full database backups, which you want to restore on your laptop. The SQL Backup GUI presently does not allow you to schedule a restore. You will have to do that manually, by setting up a… -
counting to 10 not working - restore with move error
Be thankful you are a ocean and a continent away. I was asked to restore a db to a new test server on short notice tonight, and SQL Backup turned a simple job into a nightmare. Your UI allows me to set the target drives for the files in my database, but the app errors out when you try to use them. I believe I asked about… -
Linking database to perforce fails
Discussion by S.engel · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsI am able to link database to the evulation SVN. However it is not possible to link databases to perforce. I have created my own config file SFP.xml<HooksConfig version="1" type="HooksConfig"> <!-- The name of the config file that will be displayed in the SQL Source Control user interface --> <Name>SFP</Name> <Commands… -
SQL Prompt 7.2 beta (now closed)
The stable release announcement can be found here. Beta closed - thanks to everyone who took part! This build of SQL Prompt includes:* SQL Prompt now offers suggestions when connected to Azure SQL Data Warehouse and Parallel Data Warehouse in Visual Studio (UserVoice) * SQL Prompt now shows a warning message when you try… -
Cannot use a CONTAINS or FREETEXT predicate on table
I'm trying to use sql compare but I cannot get around the problem below, anyone have any ideas? ALTER PROCEDURE dbo._CheckRulesBeforeDelete( @nUserId int, @nNodeId int, @nReturn int output)AS SET NOCOUNT ON SET @nReturn = 0 DECLARE @strObjectType nvarchar(50) DECLARE @intParentId int DECLARE @ObjectId int DECLARE… -
Re: Tools from Redgate Suite for E2E masking
Good morning @Arun72 Thank you for your post! You're absolutely right that the Redgate tools are intended to be as helpful End To End as possible, so you're correct in that the flow should be as follows: 1 - SQL Data Catalog - get the databases you wish to protect classified and tagged 2 - Data Masker for SQL Server - Once… -
Re: Property cannot be updated or deleted
That seemed to work fine and seems to be the last of the problems :D (for now ;)) Here's my final code #region SynchroniseSchema public static void SynchroniseSchema(string server, string database, string snapshotPath) { ConnectionProperties connectionProperties = new ConnectionProperties(server, database); //AJ: Fudge for… -
Re: Error: Couldn't get write lock
@Dan_J - Got an error after adding the exclusion. Following is the applicable error message from the logs: 2021-09-15 07:35:56.989 -07:00|Error|RedGate.SQLSourceControl.CommonUI.Controls.CancellableControl`2[[RedGate.SQLSourceControl.Engine.Diff.IChangeSetWithWorkspace, RedGate.SQLSourceControl.Engine,… -
Re: What is the "Improved SQL 2000" Support?
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi Dennis, Referential integrity (ON DELETE/UPDATE CASCADE) appeared in version 2.01 of SQL Compare. -Brian "dennis" <dennis@nospam.com> wrote in message news:zoLJrbEBDHA.1992@server53... > Specifically, can you tell me which version has support for Cascade Delete > settings, the version we have does not appear to capture…
>1649 results