Activity overview
Latest activity by jrandall
deactivation
We are moving our DR site and need to deactivate and uninstall SQL Backup from the old DR servers (2) then install and activate on the new servers. We have 11 licenses using the same serial no. T...
error messages
Monitoring a single server. Repository on monitored server. No issues for a couple of weeks, suddenly getting the following errors suggesting the monitor cannot connect to the monitored server. ...
highlight Begin / End
Please let me know if this capability exists already, but it would be great if SQL Prompt could highlight begin/end pairs similar to how it's done in SQL Assistant. I suppose if SSMS included a fe...
restore not recognizing default data and log directories
It would be very helpful if restore operations through the gui used the default database data and log file directories defined for a sql server instance. this is an easy registry setting to find. ...
Stopping Backup Exec does not resolve the problem / comments
Stopping Backup Exec does not resolve the problem
No anti-virus software, but we do have Backup Exec running / comments
No anti-virus software, but we do have Backup Exec running
Cut and paste error, here is the command...
DECLARE @errorcode INT
DECLARE @sqlerrorcode INT
EXECUTE master..sqlbackup N'-SQL "RESTORE LOG [TankData] FROM DISK = [E:\SQL_BKUP\TankData\LogShip\TMC-SQLHA_SUPPLYNET_TankData_LOG__20091016_005900.sqb] WITH NORECOVERY
, MOVETO = [E:\SQL_Bkup\TankData\Tlog]
, ERASEFILES = 3
, FILEOPTIONS = 1"'
, @errorcode OUT
, @sqlerrorcode OUT;
IF (@errorcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @errorcode, @sqlerrorcode)
END
GO / comments
Cut and paste error, here is the command...
DECLARE @errorcode INT
DECLARE @sqlerrorcode INT
EXECUTE master..sqlbackup N'-SQL "RESTORE LOG [TankData] FROM DISK = [E:\SQL_BKUP\TankData\LogShip\TMC-S...
File is locked
Attempting to restore a tlog backup file on the destination server in a log shipping scenario. Getting a File Locked error. I have tried performing the restore remotely (backup is located on the ...
Finally figured this out. I had previously removed those servers from my alias list in SQL Server Configuration Mgr. Forgot I still had them listed as Registered Servers in SSMS. That is where Dependency Tracker was picking them up. When I deleted them as registered servers, they no longer appeared in Dependency Tracker / comments
Finally figured this out. I had previously removed those servers from my alias list in SQL Server Configuration Mgr. Forgot I still had them listed as Registered Servers in SSMS. That is where D...
I'm running Dependency Tracker on my laptop. It gets rebooted daily. I hadn't run Dependency Tracker in weeks. / comments
I'm running Dependency Tracker on my laptop. It gets rebooted daily. I hadn't run Dependency Tracker in weeks.