Search
-
SQL error 3201
Discussion by DanielBritten · · Home› Discontinued and Previous Versions› SQL Backup Previous VersionsI am getting the following message while trying to backup a database. Any ideas? Backing up WM07NewStore (full database) on SQL2K5 instance to: E:\Backups\WM07NewStore\FULL_SQL2K5_WM07NewStore_20081014_103457_1.sqb E:\Backups\WM07NewStore\FULL_SQL2K5_WM07NewStore_20081014_103457_2.sqb… -
Re: Timing of Log Shipping Transaction Log Restores
here is a sample of the error message I get when the shipping fails: SQL Backup log file 6.4.0.56 -SQL "RESTORE LOG [LMPOS_KitchenWarehouse] FROM DISK = '\\svr-dbase02\LogShipping\LOG_LMPOS_KitchenWarehouse_*.sqb' WITH ERASEFILES = 2, FILEOPTIONS = 1, MAILTO_ONERRORONLY = 'AllDBATeam@vii.com.au', NORECOVERY, MOVETO =… -
Re: The system didn’t see the changes.
Comment by fadeev_av · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsCreate table sample:CREATE TABLE MX_Developer.dbo.MX_WF_ObjectStructure( ID_WF_Object INT NOT NULL, ID_Object_Type INT NULL, Parent_ID INT NULL, NameRU VARCHAR(100) NOT NULL, NameEN VARCHAR(100) NOT NULL, Table_Name VARCHAR(128) NULL, PK_Field VARCHAR(128) NULL, ID_WF_UsingObject INT NULL, Edit_Field VARCHAR(128)… -
Re: Using SQL Toolkit + SQL Compare to sync partial databases
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Toolkit Previous VersionsHi Justin, Provided you don't need to send any data and are concerned only with the schema, the SQL Toolkit os well suited to this task. The basic idea would be to take a 'snapshot' of the reference schema using SQL Compare, then putting the snapshot file and a custom Toolkit application into an Installer package and… -
Re: Extended Properties on Foreign Keys missing
A few more details: This morning I used SQL Compare to do a Production deployment changing a table called DimCourse. The table had to be rebuilt due to a change in column order caused by the addition of a new column. There are four different foreign keys that point to DimCourse as a referenced object. Before the… -
Re: SC not recognising "release candidate" migration scripts
Comment by datacentricity · · Home› Discontinued and Previous Versions› SQL Compare Previous Versions› SQL Compare 11I've been experiencing the same issue, our setup is as follows: SQL Source Control 5.1.1.2694 SQL Compare 11.6.3.1926 TFS 2015 source control We have just moved over to SOC v5 and on the first attempt to deploy changes (including three new v5-style migration scripts DDL - DML - DDL), SQL Compare did not find any migration… -
Re: Query for SQL uptime?
wullsy, I believe what you require can be implemented using the below script. Please try it out and let me know if you need anything further. The uptime is based on SQL Monitor's ability to connect to the monitored entity, and also to collect data. The percentage and downtime measures are based on the times that SQL… -
Re: Bug in Backup 7.7.0.18
I'm experiencing this same problem, and it is a bug. And here is why. SQL Backup Pro will stop at the first full backup that it finds (or to be more precise, the last full back that occurred before your requested restore point) regardless of whether or not it is part of the backup chain. If you use COPY_ONLY backups for… -
Performance Profiler Causes XamlParseException
Discussion by AdamsGuitar · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsI'm attempting to evaluate the Performance Profiler, and I'm using it on my WPF client application. Whenever I launch a session for my application (whether from within the Performance Profiler application or through the VS Addin), it immediately exits. When I check the Application event log, I see that my application was… -
SQL Compare 8.2 released
Discussion by Chris Auckland · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsSQL Compare 8.2 has been released. (10 May 2010) 8.2 is a maintenance release that fixes the following issues in SQL Compare 8.1: SC-4252 Trailing comma when removing schemabinding from encrypted objects SC-4514 Add support for the "View Change Tracking" user right in SQL Server 2008 SC-4531 Windows Hot Keys SC-4528 Script…
>5989 results