How can we help you today? How can we help you today?
clinford
Activity overview Badges (0) Posts (2) Comments (4)

Activity overview

Latest activity by 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
  1. Community
  2. SQL Backup Previous Versions
  3. manual backup works, but scheduled gives error
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
manual backup works, but scheduled gives error
  1. Community
  2. SQL Backup Previous Versions
Hi, I am using SQL Backup version 5.2.0.2825 and am running into a problem with scheduling backups. I can do a manual backup without problems, but when I try to schedule the backup, I get an error...
2 followers 2 comments 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
  1. Community
  2. SQL Backup Previous Versions
  3. full backup works, differential fails
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, 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
  1. Community
  2. SQL Backup Previous Versions
  3. full backup works, differential fails
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
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
  1. Community
  2. SQL Backup Previous Versions
  3. full backup works, differential fails
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
full backup works, differential fails
  1. Community
  2. SQL Backup Previous Versions
I am using Redgate Backup version 5.3.0.178 When I do a full backup, it completes successfully (in about 10 seconds). See the log file here: SQL Backup log file 5.3.0.178 -SQL "BACKUP DATABASE [Vi...
4 followers 9 comments 0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2