Activity overview
Latest activity by UrsusHorribilis
Upgrading from older versions of SQL Compare
I'm in the process of rolling out SQL Compare 8 to about 85-90 users & have been asked some questions regarding upgrading from older versions.
If a user has 4, 5, 6 or 7 (yes, I have users with tha...
Thanks, I'll give it a try. / comments
Thanks, I'll give it a try.
yes / comments
yes
The system is x64, running both sql 2000 & 2005. I checked the sqldvi.dll version, it's 2000.85.2101.0. I looked at another x64 system running sql2005 only & the sqldvi.dll version is 2000.85.2004.0. Thanks / comments
The system is x64, running both sql 2000 & 2005. I checked the sqldvi.dll version, it's 2000.85.2101.0. I looked at another x64 system running sql2005 only & the sqldvi.dll version is 2000.85.200...
SQL Backup log file
9/4/2008 3:15:33 PM: Restoring Content (database) on SQLQA10 instance from:
9/4/2008 3:15:33 PM: G:\sqlrec\content_Refresh.sqb
9/4/2008 3:15:33 PM: RESTORE DATABASE [Content] FROM DISK = 'G:\sqlrec\content_Refresh.sqb' WITH RECOVERY, MOVE 'Content_Data' TO 'F:\MSSQL.1\MSSQL\Data\Content_Data.mdf', MOVE 'Content_Log' TO 'G:\MSSQL.1\MSSQL\SQLLogs\Content_Log.ldf'
9/4/2008 3:16:03 PM: VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.)
9/4/2008 3:16:03 PM: Also check that the database is not currently in use.
9/4/2008 3:16:03 PM: SQL error 3013: RESTORE DATABASE is terminating abnormally.
9/4/2008 3:16:03 PM: SQL error 3201: Cannot open backup device 'SQLBACKUP_800160A3-D9DC-48C7-8C42-B591C24BD432'. Operating system error 0x80770006(error not found).
9/4/2008 3:16:03 PM:
9/4/2008 3:16:03 PM: Memory profile
9/4/2008 3:16:03 PM: Type Maximum Minimum Average Blk count Total
9/4/2008 3:16:03 PM:
9/4/2008 3:16:03 PM: Commit 35651584 4096 320720 884 283516928
9/4/2008 3:16:03 PM: Reserve 4261347328 4096 38924361 111 4320604160
9/4/2008 3:16:03 PM: Free 6876207382528 4096 65122139522 135 8791488835584
9/4/2008 3:16:03 PM: Private 4261347328 4096 7825732 575 4499795968
9/4/2008 3:16:03 PM: Mapped 1585152 4096 168090 53 8908800
9/4/2008 3:16:03 PM: Image 33271808 4096 259989 367 95416320
9/4/2008 3:16:03 PM: / comments
SQL Backup log file
9/4/2008 3:15:33 PM: Restoring Content (database) on SQLQA10 instance from:
9/4/2008 3:15:33 PM: G:\sqlrec\content_Refresh.sqb
9/4/2008 3:15:33 PM: RESTORE DATABASE [Content] ...
SQL Backup Failing
Version 5.2.0.2807 I lowered SQL Mem & retsarted the Instance, no luck. Any help would be much appreciated, Thanks
Restoring Content (database) on SQLQA10 instance from:
G:\sqlrec\content_Refresh...
Thanks / comments
Thanks
Programatically verify Backups run in SQLAgent
The scenario: We run nightly backups from a SQLAgent Job & have experienced failures for various reasons.
The problem: At times, even though we don't get a valid backup, the Job Step reports succe...
That worked, Thanks / comments
That worked, Thanks
Transaction Log Backup Fails
I am getting the below error when backing up transaction logs of any DB on the server. For the example below a full backup was performed & verified 10 mins before the log backup failed.
exec maste...