How can we help you today? How can we help you today?
bbrown
Activity overview Badges (0) Posts (1) Comments (3)

Activity overview

Latest activity by bbrown

I am also seeing this problem. I am trying to restore a 4.6 backup using 5.2. When I get to the Choose Database dialog box, I do not see any of the data files, nor does the ... box function. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. File locations during a restore
I am also seeing this problem. I am trying to restore a 4.6 backup using 5.2. When I get to the Choose Database dialog box, I do not see any of the data files, nor does the ... box function.
0 votes
All the databases are backed up, and log files were generated, except for the last database(VirtualCenter). There are no error messages in the SQL Logs, the Event viewer, or the Red Gate logs. My trace showed backup commands were issued for all databsaes except the last one. The backup job started at 7:45 PM. The first four databases took less than a minute to backup. At 7:46 PM, a transaction log backup for the last databse was started. All I see in the logs for the last database, is the log job. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup ending incompletely
All the databases are backed up, and log files were generated, except for the last database(VirtualCenter). There are no error messages in the SQL Logs, the Event viewer, or the Red Gate logs. My...
0 votes
We are running SQL Backup 4 on a SQL Server 2005 box. The stored procedure producte the following commands: EXEC (master..sqlbackup N' -SQL "BACKUP DATABASE [DBAShared] TO DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Current\DBAShared\RedGate_FULL_DDPOKVC1_DBAShared_20070829_140122.sqb'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', INIT, VERIFY, ERASEFILES_ATSTART = 2, COMPRESSION = 3"') EXEC (master..sqlbackup N' -SQL "BACKUP DATABASE [master] TO DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Current\master\RedGate_FULL_DDPOKVC1_master_20070829_140122.sqb'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', INIT, VERIFY, ERASEFILES_ATSTART = 2, COMPRESSION = 3"') EXEC (master..sqlbackup N' -SQL "BACKUP DATABASE [model] TO DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Current\model\RedGate_FULL_DDPOKVC1_model_20070829_140122.sqb'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', INIT, VERIFY, ERASEFILES_ATSTART = 2, COMPRESSION = 3"') EXEC (master..sqlbackup N' -SQL "BACKUP DATABASE [msdb] TO DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Current\msdb\RedGate_FULL_DDPOKVC1_msdb_20070829_140122.sqb'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', INIT, VERIFY, ERASEFILES_ATSTART = 2, COMPRESSION = 3"') EXEC (master..sqlbackup N' -SQL "BACKUP DATABASE [VirtualCenter] TO DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Current\VirtualCenter\RedGate_FULL_DDPOKVC1_VirtualCenter_20070829_140122.sqb'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', INIT, VERIFY, ERASEFILES_ATSTART = 2, COMPRESSION = 3"') What I mean by execution plan is the compiled executable that is cached for each stored procedure. Also, as I mentioned, I have seen a Log backup and a Database backup attempt to execute at the same time and I have seen the Log backup abort, then retry and execute ok. However, these are on SQL Server 2000 boxes and also give error messages. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup ending incompletely
We are running SQL Backup 4 on a SQL Server 2005 box. The stored procedure producte the following commands: EXEC (master..sqlbackup N' -SQL "BACKUP DATABASE [DBAShared] TO DISK = ''D:\Program Fil...
0 votes
SQL Backup ending incompletely
  1. Community
  2. SQL Backup Previous Versions
I posted this problem in the SQLServerCentral forums. Someone from Red Gate suggested I post it here. We have recently changed the backup on servers with large databases to use Red Gate SQL Backup...
3 followers 6 comments 0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2