Posts
Sort by recent activity
SQL Prompt Error in the Application and Services Log
Everytime I start SSMS I see the following error get logged to the following log.
Should I be concerned?
Event Viewer (local) --> Applications and Services Logs --> Redgate Software.
Log Name: ...
RESTORE VERIFY ONLY
We are having problems with the verify portion of a BACKUP command.
The following works in in 1:07 (min:sec) to backup a 3.2 GB database, compressed 83%:
EXEC master..sqlbackup '-SQL "BACKUP DATABA...
Cannot connect to an instance of SQL Server with SQL Backup
We have 3 instances of SQL Server one of our test machines. Two of the instances show up fine in the SQL Backup interface and the components install fine. I've just upgraded two of the instances to...
Need syntax for include with wild card
I'm trying to figure out the SQLCompare syntax for including all the objects that begin with a certain prefix (i.e. Log*).
I've tried the following to no avail:
/Include:table:Log
/Include:table:Lo...
SQL Compare Error
SQL Compare is generating the following ALTER TABLE statement which errors:
ALTER TABLE [dbo].[ims_subscriber_details]
ADD CONSTRAINT [PK_ims_subscriber_details]
PRIMARY KEY CLUSTERED ([detail_id]...