Activity overview
Latest activity by jchertudi
May have answered my own question, there seems to be a silent error in the CMD line Compare. If I try to perform this same compare via the application, I get an error about the SCHEMABINDING on these Views. One of the tables in the VIEW is being altered, and the Compare from the application fails. The CMD line drops the views, changes the table, then recreates them, but doesn't add the full text indexing.
I've been told prior that MSSQL won't allow creation of a schema bound view and adding a full text index in one step, bummer. / comments
May have answered my own question, there seems to be a silent error in the CMD line Compare. If I try to perform this same compare via the application, I get an error about the SCHEMABINDING on the...
CMD line compare quietly removes Full text indexing
SQL Compare Command Line V10.4.8.87
I created this view with a batch SQL file on many databases, copying and pasting the info out of the SQL Compare application
-- View
CREATE VIEW [dbo].[SV_V] WIT...
I have a very similar issue, using SQL Compare 8.5. On a Full Text Indexed View I have set
ALTER FULLTEXT INDEX ON [ViewName]
SET CHANGE_TRACKING AUTO
But when I compare this to a similar database that has
ALTER FULLTEXT INDEX ON [ViewName]
SET CHANGE_TRACKING MANUAL
the Compare does not recognize them as different. I see this in the compare preview:a
CREATE FULLTEXT INDEX ON [dbo].[ViewName] KEY INDEX [IX_ID] ON [Storage] WITH CHANGE_TRACKING OFF / comments
I have a very similar issue, using SQL Compare 8.5. On a Full Text Indexed View I have set
ALTER FULLTEXT INDEX ON [ViewName]
SET CHANGE_TRACKING AUTO
But when I compare this to a similar database ...
Thanks for the response Peter! I had thought this would be the case and tried to do such a restore, but got an error message.
Also, the SQB UI doesn't seem to support such a restore, when I select a transaction log, it only selects files back to the prior Full backup. Do these sort of restores need to be run via SSMS?? / comments
Thanks for the response Peter! I had thought this would be the case and tried to do such a restore, but got an error message.
Also, the SQB UI doesn't seem to support such a restore, when I select ...
For the last few years we have had 0 issues of backup corruption, though I would not argue with you that these things do happen. We may have to reconsider the size of our backup directory in order to accommodate a full every day and transaction logs backups hourly. the other downside to that is that it already takes the SQB UI a few minutes to load all of the backup history from our systems, multiplying the number of files by 24 would really over do it.
Still back to original question... there is no method to restore to a point in time between a Log and Full Backup, correct? I already started doing a log backup right ahead of our weekend full backup. / comments
For the last few years we have had 0 issues of backup corruption, though I would not argue with you that these things do happen. We may have to reconsider the size of our backup directory in order ...
The backup strategy has worked very well for us, we have 3000 relatively small databases, and one TLOG backup has all the transactions.
I was hoping you might offer some ideas relative to the window between a TLOG backup and a FULL backup. There must be some way to full backup without losing those transactions. / comments
The backup strategy has worked very well for us, we have 3000 relatively small databases, and one TLOG backup has all the transactions.
I was hoping you might offer some ideas relative to the windo...
restore to point in time between LOG and FULL backup
We schedule our Log backups to run each weeknight at 6pm, then run a full backup at 2am on Sunday. Possible to then restore to 1pm on Saturday, which falls between the LOG and FULL backup?
If not, ...
can't launch SQB 6.3 in Win 7 Pro x64
I have a new Windows 7 Pro x64 desktop that i installed the SQL Backup 6.3 client on to. When launching the client, i get the error below.
SQLBackup
Font 'Arial' does not support style 'Bold'.
Argu...
back up log RIGHT before full backup
Using SQL Backup 5.4 on Windows 08/SQL 08
We run full backups each Sunday on 2000 databases, TLOG backups every weeknight at 6pm. I thought I could restore to any point in time with this model, but...