How can we help you today? How can we help you today?
meklembl
Activity overview Badges (0) Posts (34) Comments (71)

Comments

Sort by recent activity
Is the reverse true as well when doing the restore? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. How much space do I need?
Is the reverse true as well when doing the restore?
0 votes
So "something" stopped the backup, but then it restarted and was successful. Is that correct? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1010
So "something" stopped the backup, but then it restarted and was successful. Is that correct?
0 votes
Command: EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [MasterSearch] TO DISK = ''\\SqlRptg\E\Backups\Hercules\<AUTO>.sqb'' WITH DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 2, THREADCOUNT = 4"' Results: SQL Backup log file 6.4.0.56 -SQL "BACKUP DATABASE [MasterSearch] TO DISK = '\\SqlRptg\E\Backups\Hercules\<AUTO>.sqb' WITH DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 2, THREADCOUNT = 4 " ERRORS AND WARNINGS 6/30/2010 7:20:08 AM: Backing up MasterSearch (full database) to: 6/30/2010 7:20:08 AM: \\SqlRptg\E\Backups\Hercules\MasterSearch_db_20100630_072008.sqb 6/30/2010 7:20:08 AM: BACKUP DATABASE [MasterSearch] TO VIRTUAL_DEVICE = 'SQLBACKUP_80455E1A-BCF7-4794-A2AA-5C04A6E414AF', VIRTUAL_DEVICE = 'SQLBACKUP_80455E1A-BCF7-4794-A2AA-5C04A6E414AF01', VIRTUAL_DEVICE = 'SQLBACKUP_80455E1A-BCF7-4794-A2AA-5C04A6E414A F02', VIRTUAL_DEVICE = 'SQLBACKUP_80455E1A-BCF7-4794-A2AA-5C04A6E414AF03' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (MasterSearch), 6/30/2010 7:20:08 AM', DESCRIPTION = N'Backup on 6/30/2010 7:20:08 AM Server: HERCULES Database: MasterSearch', FORMAT 6/30/2010 7:20:38 AM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName] 6/30/2010 7:21:33 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally. 6/30/2010 7:21:33 AM: SQL error 3201: Cannot open backup device 'SQLBACKUP_80455E1A-BCF7-4794-A2AA-5C04A6E414AF'. Operating system error 0x80070002(The system cannot find the file specified.). 6/30/2010 7:21:33 AM: 6/30/2010 7:21:35 AM: Memory profile 6/30/2010 7:21:35 AM: Type Maximum Minimum Average Blk count Total 6/30/2010 7:21:35 AM: 6/30/2010 7:21:35 AM: Commit 935673856 4096 578550 12469 7213944832 6/30/2010 7:21:35 AM: Reserve 1241448448 4096 134155 11271 1512067072 6/30/2010 7:21:35 AM: Free 6872180850688 4096 30618003291 287 8787366944768 6/30/2010 7:21:35 AM: Private 1241448448 4096 370821 23222 8611209216 6/30/2010 7:21:35 AM: Mapped 1585152 4096 132683 61 8093696 6/30/2010 7:21:35 AM: Image 33284096 4096 233498 457 106708992 6/30/2010 7:21:35 AM: PROCESSES COMPLETED SUCCESSFULLY 6/30/2010 7:21:35 AM: Warning 300: Backup failed. Retry attempt: 1 6/30/2010 7:21:38 AM: BACKUP DATABASE [MasterSearch] TO VIRTUAL_DEVICE = 'SQLBACKUP_00C3C784-B8AC-4C46-80F9-E1EB1B11EB9E', VIRTUAL_DEVICE = 'SQLBACKUP_00C3C784-B8AC-4C46-80F9-E1EB1B11EB9E01', VIRTUAL_DEVICE = 'SQLBACKUP_00C3C784-B8AC-4C46-80F9-E1EB1B11EB9 E02', VIRTUAL_DEVICE = 'SQLBACKUP_00C3C784-B8AC-4C46-80F9-E1EB1B11EB9E03' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 524288, NAME = N'Database (MasterSearch), 6/30/2010 7:20:08 AM', DESCRIPTION = N'Backup on 6/30/2010 7:20:08 AM Server: HERCULES Database: MasterSearch', FORMAT 6/30/2010 8:23:23 AM: Database size : 202.819 GB 6/30/2010 8:23:23 AM: Compressed data size: 51.444 GB 6/30/2010 8:23:23 AM: Compression rate : 74.64% 6/30/2010 8:23:23 AM: Processed 21431344 pages for database 'MasterSearch', file 'MasterSearch_Data' on file 1. 6/30/2010 8:23:23 AM: Processed 597904 pages for database 'MasterSearch', file 'DFSearchDetails' on file 1. 6/30/2010 8:23:23 AM: Processed 380008 pages for database 'MasterSearch', file 'DFTables' on file 1. 6/30/2010 8:23:23 AM: Processed 1058680 pages for database 'MasterSearch', file 'DFIndexes' on file 1. 6/30/2010 8:23:23 AM: Processed 4134 pages for database 'MasterSearch', file 'MasterSearch_Log' on file 1. 6/30/2010 8:23:23 AM: BACKUP DATABASE successfully processed 23472070 pages in 3700.732 seconds (51.958 MB/sec). / comments
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1010
Command: EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [MasterSearch] TO DISK = ''\\SqlRptg\E\Backups\Hercules\<AUTO>.sqb'' WITH DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 2, THR...
0 votes
I've had the same issue with both SSMS 2005 and SSMS 2008. I never gave it a thought that the issue may be with SQL Prompt. I had thought it was more with Vista and User Account Control settings. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Management Studio 2005 hangs upon start
I've had the same issue with both SSMS 2005 and SSMS 2008. I never gave it a thought that the issue may be with SQL Prompt. I had thought it was more with Vista and User Account Control settings.
0 votes
Select getdate() go ALTER DATABASE [ATS_Barclays] SET OFFLINE WITH ROLLBACK IMMEDIATE GO Select getdate() go ALTER DATABASE [ATS_Barclays] SET ONLINE GO Select getdate() go Results times 2010-05-10 09:39:00.650 (1 row(s) affected) 2010-05-10 09:39:01.140 (1 row(s) affected) 2010-05-10 09:39:01.437 (1 row(s) affected) / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore error VDI error 1010
Select getdate() go ALTER DATABASE [ATS_Barclays] SET OFFLINE WITH ROLLBACK IMMEDIATE GO Select getdate() go ALTER DATABASE [ATS_Barclays] SET ONLINE GO Select getdate() go Results times 2010-05-10...
0 votes
Peter, It appears that our network got very busy on Friday and this caused a twofold problem. I store my backups on a file server (not shared by a lot of users) and was restoring another database from that server. I've been able to do this before, but I think it was the proverbial straw that broke the camel's back. The server was restoring one of the larger databases and could not handle the load of another restore. Rather than saying, "Hey buddy. I'm too busy to handle another request from you." It gave me the cryptic VDI error. I was worried that my backups were corrupt or something as heinous. Thanks for your help, Larry / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore error VDI error 1010
Peter, It appears that our network got very busy on Friday and this caused a twofold problem. I store my backups on a file server (not shared by a lot of users) and was restoring another database ...
0 votes
SQL Backup log file 6.4.0.56 -SQL "RESTORE DATABASE [ATS_Barclays] FROM DISK = '\\Themis\Backups\Hercules\ATS_Barclays_db_20100507_004006.sqb' WITH RECOVERY, DISCONNECT_EXISTING, REPLACE, ORPHAN_CHECK " ERRORS AND WARNINGS 5/7/2010 3:03:28 PM: Restoring ATS_Barclays (database) from: 5/7/2010 3:03:28 PM: \\Themis\Backups\Hercules\ATS_Barclays_db_20100507_004006.sqb 5/7/2010 3:04:00 PM: ALTER DATABASE [ATS_Barclays] SET ONLINE RESTORE DATABASE [ATS_Barclays] FROM VIRTUAL_DEVICE = 'SQLBACKUP_A27A2A89-0658-4BCC-9CA2-693A968C50F5', VIRTUAL_DEVICE = 'SQLBACKUP_A27A2A89-0658-4BCC-9CA2-693A968C50F501', VIRTUAL_DEVICE = 'SQLBACKUP_A27A2A89-0658-4BCC-9CA2-693A968C50F502', VIRTUAL_DEVICE = 'SQLBACKUP_A27A2A89-0658-4BCC-9CA2-693A968C50F503' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, REPLACE 5/7/2010 3:04:30 PM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName] 5/7/2010 3:04:30 PM: Also check that the database is not currently in use. 5/7/2010 3:04:57 PM: SQL error 3013: RESTORE DATABASE is terminating abnormally. 5/7/2010 3:04:57 PM: SQL error 3201: Cannot open backup device 'SQLBACKUP_A27A2A89-0658-4BCC-9CA2-693A968C50F5'. Operating system error 0x80070002(The system cannot find the file specified.). 5/7/2010 3:04:57 PM: 5/7/2010 3:04:57 PM: Memory profile 5/7/2010 3:04:57 PM: Type Maximum Minimum Average Blk count Total 5/7/2010 3:04:57 PM: 5/7/2010 3:04:57 PM: Commit 172105728 4096 145407 37684 5479530496 5/7/2010 3:04:57 PM: Reserve 469696512 4096 35401 36697 1299120128 5/7/2010 3:04:57 PM: Free 6874127007744 4096 33675533739 261 8789314306048 5/7/2010 3:04:57 PM: Private 469696512 4096 89855 73851 6635892736 5/7/2010 3:04:57 PM: Mapped 25165824 4096 539501 63 33988608 5/7/2010 3:04:57 PM: Image 33259520 4096 232910 467 108769280 5/7/2010 3:04:57 PM: / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore error VDI error 1010
SQL Backup log file 6.4.0.56 -SQL "RESTORE DATABASE [ATS_Barclays] FROM DISK = '\\Themis\Backups\Hercules\ATS_Barclays_db_20100507_004006.sqb' WITH RECOVERY, DISCONNECT_EXISTING, REPLACE, ORPHAN_CH...
0 votes
SQL Prompt 4.0.4.14? The last I can find on your site is 4.0.3.12. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Temp tables and Suggestions Not Showing
SQL Prompt 4.0.4.14? The last I can find on your site is 4.0.3.12.
0 votes
Thanks. And I see the light. I may not fully like it, but I do understand. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Interactive HTML works differently
Thanks. And I see the light. I may not fully like it, but I do understand.
0 votes
It could be if the users were made aware of how to fully unzip the files. What changed between SQL Compare 7 and SQL Compare 8 that made the Interactive HTML so different? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Interactive HTML works differently
It could be if the users were made aware of how to fully unzip the files. What changed between SQL Compare 7 and SQL Compare 8 that made the Interactive HTML so different?
0 votes
Total activity
150
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
45