Comments
Sort by recent activity
No anti-virus software, but we do have Backup Exec running / comments
No anti-virus software, but we do have Backup Exec running
Stopping Backup Exec does not resolve the problem / comments
Stopping Backup Exec does not resolve the problem
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...
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.
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...
Thanks for the explanation. I was hoping they were related to the new network resilience feature. How does one enable/use network resilience from a command line? / comments
Thanks for the explanation. I was hoping they were related to the new network resilience feature. How does one enable/use network resilience from a command line?
As far as I know, I have the most recent version of SQL Prompt, and to the best of my recollection, I have not altered the Triggering list. Try typing this into an new SSMS query window:
SET NOCOUNT ON;
As soon as I type the semicolon, a list of keywords pops up, beginning with "ALTER" / comments
As far as I know, I have the most recent version of SQL Prompt, and to the best of my recollection, I have not altered the Triggering list. Try typing this into an new SSMS query window:
SET NOCOU...
The activity monitor indicates SQL Backup (actually the SQL Backup executable). What other application could possibly be running it? / comments
The activity monitor indicates SQL Backup (actually the SQL Backup executable). What other application could possibly be running it?
Yes, that's what it looks like to me. When I open the Activity Monitor there are the same number of Process IDs as the number of threads I specified for the SQL Backup task. When SQL Backup is not actively executing a backup, the processes have a status of sleeping. / comments
Yes, that's what it looks like to me. When I open the Activity Monitor there are the same number of Process IDs as the number of threads I specified for the SQL Backup task. When SQL Backup is no...
SQL Server 2005 Activity Monitor. / comments
SQL Server 2005 Activity Monitor.