How can we help you today? How can we help you today?
paulnxweb
Activity overview Badges (0) Posts (7) Comments (7)

Comments

Sort by recent activity
Well we only use the redgate software to do backup so there is no competing backup process. THe problem has not appeared again so far. With our upgrade to SQL 2005 and your insight, I was hoping you might be able to see something we over looked in the logs Thanks for taking look / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL error 3201: Cannot open backup device 'SQLBACKUP_D71F944
Well we only use the redgate software to do backup so there is no competing backup process. THe problem has not appeared again so far. With our upgrade to SQL 2005 and your insight, I was hoping...
0 votes
Our log dump from our production server 10/04/2007 12:00:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:5681:1<c/> last LSN: 65992:7486:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_2139343F-FE4C-4417-9B26-FE9443E4DBCB'}). This is an informational message only. No user action is required.,,,, 10/04/2007 12:00:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:5681:1<c/> last LSN: 65992:7486:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_2139343F-FE4C-4417-9B26-FE9443E4DBCB'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/04/2007 11:55:02,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:3426:1<c/> last LSN: 65992:5681:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_B86EF28A-AE03-4B1F-8C83-34CEA815DC0A'}). This is an informational message only. No user action is required.,,,, 10/04/2007 11:55:02,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:3426:1<c/> last LSN: 65992:5681:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_B86EF28A-AE03-4B1F-8C83-34CEA815DC0A'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/04/2007 11:50:03,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:882:1<c/> last LSN: 65992:3426:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_1915F6F2-6364-4476-ABF6-64409245781E'}). This is an informational message only. No user action is required.,,,, 10/04/2007 11:50:03,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:882:1<c/> last LSN: 65992:3426:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_1915F6F2-6364-4476-ABF6-64409245781E'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/04/2007 11:45:10,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65991:29785:1<c/> last LSN: 65992:882:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_E27EB28E-8DFE-4A64-A524-A012CDC705B9'}). This is an informational message only. No user action is required.,,,, 10/04/2007 11:45:10,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65991:29785:1<c/> last LSN: 65992:882:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_E27EB28E-8DFE-4A64-A524-A012CDC705B9'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/04/2007 11:44:07,spid65,Unknown,Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.,,,, 10/04/2007 11:44:07,MSSQLSERVER,Information,Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.,Server,1073749952,mycompany1\narn,mycompany1 10/04/2007 11:40:05,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:21504:1<c/> last LSN: 65991:29785:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_086FB579-87EF-4E48-AF8C-70F62AED9AB3'}). This is an informational message only. No user action is required.,,,, 10/04/2007 11:40:05,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:21504:1<c/> last LSN: 65991:29785:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_086FB579-87EF-4E48-AF8C-70F62AED9AB3'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/04/2007 11:39:31,Backup,Unknown,Database backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> pages dumped: 1889744<c/> first LSN: 65991:22952:269<c/> last LSN: 65991:29634:1<c/> number of dump devices: 8<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB01'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB02'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB03'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB04'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB05'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB06'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB07'}). This is an informational message only. No user action is required.,,,, 10/04/2007 11:39:31,MSSQLSERVER,Information,Database backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> pages dumped: 1889744<c/> first LSN: 65991:22952:269<c/> last LSN: 65991:29634:1<c/> number of dump devices: 8<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB01'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB02'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB03'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB04'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB05'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB06'<c/> 'SQLBACKUP_9F17F4ED-0451-4AE1-8004-14913763B2EB07'}). This is an informational message only. No user action is required.,Backup,1073760088,mycompany1\redgate,mycompany1 10/04/2007 11:39:29,spid67,Unknown,Changing the status to RESUME for full-text catalog "candidates" (7) in database "Assesspoint" (8). This is an informational message only. No user action is required.,,,, 10/04/2007 11:20:02,spid67,Unknown,Changing the status to PAUSE for full-text catalog "candidates" (7) in database "Assesspoint" (8). This is an informational message only. No user action is required.,,,, 10/04/2007 00:00:44,spid18s,Unknown,This instance of SQL Server has been using a process ID of 1084 since 9/29/2007 3:53:06 PM (local) 9/29/2007 7:53:06 PM (UTC). This is an informational message only; no user action is required.,,,, 10/04/2007 00:00:44,MSSQLSERVER,Information,This instance of SQL Server has been using a process ID of 1084 since 9/29/2007 3:53:06 PM (local) 9/29/2007 7:53:06 PM (UTC). This is an informational message only; no user action is required.,Server,1073759001,,mycompany1 10/03/2007 21:23:15,SceCli,Information,Security policy in the Group policy objects has been applied successfully.,(0),1073743528,,mycompany1 10/03/2007 21:15:22,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:19598:1<c/> last LSN: 65987:21504:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_778DE3DE-2721-46DB-A04F-FB340D179219'}). This is an informational message only. No user action is required.,,,, 10/03/2007 21:15:22,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:19598:1<c/> last LSN: 65987:21504:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_778DE3DE-2721-46DB-A04F-FB340D179219'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/03/2007 21:15:19,spid62,Unknown,Using 'xp_sqlbackup.dll' version '0004.05.00' to execute extended stored procedure 'sqbmemory'. This is an informational message only; no user action is required.,,,, 10/03/2007 21:15:19,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG Assesspoint. Check the backup application log for detailed messages.,,,, 10/03/2007 21:15:19,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.,,,, 10/03/2007 21:15:19,Backup,Unknown,Cannot open backup device 'SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F'. Operating system error 0x80070002(The system cannot find the file specified.).,,,, 10/03/2007 21:15:19,Backup,Unknown,Error: 3201<c/> Severity: 16<c/> State: 7.,,,, 10/03/2007 21:15:19,MSSQLSERVER,Information,Using 'xp_sqlbackup.dll' version '0004.05.00' to execute extended stored procedure 'sqbmemory'. This is an informational message only; no user action is required.,Server,1073749952,mycompany1\redgate,mycompany1 10/03/2007 21:15:19,MSSQLSERVER,Error,BACKUP failed to complete the command BACKUP LOG Assesspoint. Check the backup application log for detailed messages.,Backup,3221228513,mycompany1\redgate,mycompany1 10/03/2007 21:15:19,MSSQLSERVER,Error,Cannot open backup device 'SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F'. Operating system error 0x80070002(The system cannot find the file specified.).,Backup,3221228673,mycompany1\redgate,mycompany1 10/03/2007 21:15:19,SQLVDI,Error,SQLVDI: Loc=SVDS::Open. Desc=Open(Control). ErrorCode=(2)The system cannot find the file specified.<nl/>. Process=1084. Thread=212. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1 10/03/2007 21:15:17,SQLVDI,Error,SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3740. Thread=3152. Client. Instance=. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1 10/03/2007 21:15:17,SQLVDI,Error,SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0). Process=3740. Thread=3152. Client. Instance=. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1 10/03/2007 21:10:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:18610:1<c/> last LSN: 65987:19598:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_70EB5CA3-0A1E-4E28-9B58-8AF4A0C9A1D5'}). This is an informational message only. No user action is required.,,,, 10/03/2007 21:10:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:18610:1<c/> last LSN: 65987:19598:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_70EB5CA3-0A1E-4E28-9B58-8AF4A0C9A1D5'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/03/2007 21:05:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:17514:1<c/> last LSN: 65987:18610:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_BB6BFF8F-88DA-47C4-8F6D-587B200E193A'}). This is an informational message only. No user action is required.,,,, 10/03/2007 21:05:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:17514:1<c/> last LSN: 65987:18610:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_BB6BFF8F-88DA-47C4-8F6D-587B200E193A'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/03/2007 21:00:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:16317:1<c/> last LSN: 65987:17514:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_96CEACFB-1969-464F-A6F4-13036346DAA9'}). This is an informational message only. No user action is required.,,,, 10/03/2007 21:00:01,SQLVDI,Error,SQLVDI: Loc=SVDS::Open. Desc=Open(Control). ErrorCode=(2)The system cannot find the file specified.<nl/>. Process=1084. Thread=212. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1 10/03/2007 20:55:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:15391:1<c/> last LSN: 65987:16317:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_B242D625-E019-489B-9C90-11A0D04B4C8D'}). This is an informational message only. No user action is required.,,,, 10/03/2007 20:55:01,SQLVDI,Error,SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3740. Thread=3152. Client. Instance=. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1 10/03/2007 20:50:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:14351:1<c/> last LSN: 65987:15391:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_75F6DFA5-FDA9-449D-A61C-6A5EF60B0773'}). This is an informational message only. No user action is required.,,,, 10/03/2007 20:50:01,SQLVDI,Error,SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0). Process=3740. Thread=3152. Client. Instance=. VD=Global\SQLBACKUP_D71F9445-A707-4CAA-B981-1E92323DDA3F_SQLVDIMemoryName_0.,(0),1,,mycompany1 10/03/2007 20:45:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:12761:1<c/> last LSN: 65987:14351:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_6C1D0756-3401-4ABA-980D-B1E1804F5108'}). This is an informational message only. No user action is required.,,,, 10/03/2007 20:45:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:18610:1<c/> last LSN: 65987:19598:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_70EB5CA3-0A1E-4E28-9B58-8AF4A0C9A1D5'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/03/2007 20:40:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:11610:1<c/> last LSN: 65987:12761:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_8A8AA851-B29E-4DDF-AC7E-37EA7EB9D0C5'}). This is an informational message only. No user action is required.,,,, 10/03/2007 20:40:01,MSSQLSERVER,Information,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:17514:1<c/> last LSN: 65987:18610:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_BB6BFF8F-88DA-47C4-8F6D-587B200E193A'}). This is an informational message only. No user action is required.,Backup,1073760089,mycompany1\redgate,mycompany1 10/03/2007 20:35:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65987:10375:1<c/> last LSN: 65987:11610:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_FFE73139-1FFF-4F95-9A91-01B2341CD98C'}). This is an informational message only. No user action is required.,,,, / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL error 3201: Cannot open backup device 'SQLBACKUP_D71F944
Our log dump from our production server 10/04/2007 12:00:01,Backup,Unknown,Log was backed up. Database: Assesspoint<c/> creation date(time): 2007/09/29(14:42:23)<c/> first LSN: 65992:5681:1<c/> las...
0 votes
Nevermind. I found "-I" command for specifying the instance for SQLBACKUPC.exe The way the Redgate manual was written made me focus on the "-SQL" parameter section. The answers is part of SQLBACKUPC.exe windows command line parameter. So below works. "C:\Program Files\Red Gate\SQL Backup\MSSQL2K5STD\SQLBackupC.exe" -I MSSQL2K5STD -SQL ".......switches" / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup cmd line using named instance
Nevermind. I found "-I" command for specifying the instance for SQLBACKUPC.exe The way the Redgate manual was written made me focus on the "-SQL" parameter section. The answers is part of SQLBAC...
0 votes
petey wrote: sqb2mtf cannot convert multiple files, nor files matching search patterns. You need to name the file explicitly. So how do you propose converting multiple compressed files to the Microsoft Tape format? We have large database and have used the backup product to compress to 8 individual files to ship to our stand by server. Being able to split in mutiple files (with the sqb2mtf utility to restore) was one of main reason we bought two licenses from Redgate. Now we want to convert these 8 files to the microsoft tape format / comments
  1. Community
  2. SQL Backup Previous Versions
  3. sqb2mtf errrors
petey wrote: sqb2mtf cannot convert multiple files, nor files matching search patterns. You need to name the file explicitly. So how do you propose converting multiple compressed files to th...
0 votes
thanks. that wasn't an obvious solution.... at least to me. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. sqb2mtf errrors
thanks. that wasn't an obvious solution.... at least to me.
0 votes
Found my own answer. This is a permission issue with the registry key HKEY_LOCAL_MACHINE/Software/Red Gate as the Red Gate Backup Agent service user must have write permission to this key. Also I originally had problems installing Red Gate Backup under windows 2003 (no problems under Win 2000) and was forced to run the service under local system and then later change to my own downgraded service user. This implies that if you create a dedicated user to run red gate, you must 1) make sure the user has permission to write to registry key HKEY_LOCAL_MACHINE/Software/Red Gate 2) make sure the redgate service user has write permission to the "red gate log directory" (also got burnt here previously) Not aware if the above info is part of RedGate installation docs / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL backup GUI freezes when saving options in Windows 2003
Found my own answer. This is a permission issue with the registry key HKEY_LOCAL_MACHINE/Software/Red Gate as the Red Gate Backup Agent service user must have write permission to this key. Also I ...
0 votes
thanks for the helpful info, looks like I will need to use the command line interface and custom code/scripts / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Log Shipping and Best Practices
thanks for the helpful info, looks like I will need to use the command line interface and custom code/scripts
0 votes
Total activity
19
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
5