User profile for clinford

Matthew, Thank you very much for your reply. I don't know very much about database management, but your reply gave me enough to get it running. I was able to find the SQL server agent, and get it running with the SQL Server Configuration Manager. (It does look like they are using different authentication--the DB is running with a specific userid, and SQL Backup 5 is running with windows authentication) I am still wondering though why I was able to do a manual backup, when the scheduled one didn't work. Is a scheduled backup always tied to the SQL server agent, and a manual backup is a direct connection perhaps? Thanks! / comments

Matthew, Thank you very much for your reply. I don't know very much about database management, but your reply gave me enough to get it running. I was able to find the SQL server agent, and get it...

0 votes

Matthew, I don't think so. I searched through the logs, and didn't find any occurrences of the message "IO is frozen for snapshot" For now, I may just need to do daily full backups, rather than differential backups. . . [image] / comments

Matthew, I don't think so. I searched through the logs, and didn't find any occurrences of the message "IO is frozen for snapshot" For now, I may just need to do daily full backups, rather than di...

0 votes

Matthew, Thank you for the reply. However, I don't think that is the case--as it still fails if I do a full backup, immediately followed by a differential. . . Though I would be happy to do some more digging on that if you can give me some clues on where to look--I have virtually no experience with database admin :-( Here are the latest logs: First the full backup: SQL Backup log file 5.3.0.178 -SQL "BACKUP DATABASE [Viewpoint] TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<AUTO>.sqb' WITH COMPRESSION = 1 " PROCESSES COMPLETED SUCCESSFULLY 9/17/2008 1:12:37 PM: Backing up Viewpoint (full database) to: 9/17/2008 1:12:37 PM: [image] \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FULL_(local)_Viewpoint_20080917_131237.sqb 9/17/2008 1:12:38 PM: BACKUP DATABASE [Viewpoint] TO VIRTUAL_DEVICE = 'SQLBACKUP_F88DE86F-725E-48B4-B11F-44FD3DC2F27B' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (Viewpoint), 9/17/2008 1:12:37 PM', DESCRIPTION = N'Backup on 9/17/2008 1:12:37 PM Server: IRONHIDE Database: Viewpoint' 9/17/2008 1:12:47 PM: Database size : 1.427 GB 9/17/2008 1:12:47 PM: Compressed data size: 689.259 MB 9/17/2008 1:12:47 PM: Compression rate : 52.84% Processed 124024 pages for database 'Viewpoint', file 'VPProd' on file 1. Processed 1 pages for database 'Viewpoint', file 'VPProd_log' on file 1. BACKUP DATABASE successfully processed 124025 pages in 8.861 seconds (114.661 MB/sec). 9/17/2008 1:12:47 PM: SQL Backup process ended. Here is the failing differential log: SQL Backup log file 5.3.0.178 -SQL "BACKUP DATABASE [Viewpoint] TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<AUTO>.sqb' WITH COMPRESSION = 1, DIFFERENTIAL " ERRORS AND WARNINGS 9/17/2008 1:13:13 PM: Backing up Viewpoint (differential database) to: 9/17/2008 1:13:13 PM: [image] \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DIFF_(local)_Viewpoint_20080917_131313.sqb 9/17/2008 1:13:13 PM: BACKUP DATABASE [Viewpoint] TO VIRTUAL_DEVICE = 'SQLBACKUP_2BB50CC0-BBB8-47DF-8F57-CFB5BFA5B6EB' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (Viewpoint), 9/17/2008 1:13:13 PM', DESCRIPTION = N'Backup on 9/17/2008 1:13:13 PM Server: IRONHIDE Database: Viewpoint', DIFFERENTIAL 9/17/2008 1:22:49 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 and that you have the SQL Server System Administrator server role; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName] 9/17/2008 1:22:49 PM: SQL error 3013: BACKUP DATABASE is terminating abnormally. 9/17/2008 1:22:49 PM: SQL error 3035: Cannot perform a differential backup for database "Viewpoint", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. Any other ideas on what I can look at/for? Thanks! / comments

Matthew, Thank you for the reply. However, I don't think that is the case--as it still fails if I do a full backup, immediately followed by a differential. . . Though I would be happy to do some m...

0 votes

Matthew, Thanks again for the reply. I have tried what I *think* is a Native Full/Differential backup (using Microsoft SQL Server Management Studio)--and get the same error about the database not existing. Any ideas on what I need to do to resolve that? (The backup location is the same for both the full and differential backups that I do. . .) Here is the error I get from there: TITLE: Microsoft SQL Server Management Studio Backup failed for Server 'IRONHIDE'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName ... nkId=20476 ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Cannot perform a differential backup for database "Viewpoint", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName ... nkId=20476 BUTTONS: OK Thanks again for your help. / comments

Matthew, Thanks again for the reply. I have tried what I *think* is a Native Full/Differential backup (using Microsoft SQL Server Management Studio)--and get the same error about the database not ...

0 votes

How can we help you today?

clinford

Comments