Comments
Sort by recent activity
The dir.txt file does get created properly. / comments
The dir.txt file does get created properly.
That's it - well almost. I see the NOWRITE option causes the backup file to not be created.
This hung:
master..sqlbackup '-sql "BACKUP DATABASE isi TO DISK = [D:\SQL_DATA\MSSQL\BACKUP\isi.sqb] WITH INIT"'
This did not:
master..sqlbackup '-sql "BACKUP DATABASE isi TO DISK = [D:\SQL_DATA\MSSQL\BACKUP\isi.sqb] WITH INIT, NOWRITE"'
=======
SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
Serial number: <removed>
Backing up isi (full database) to [image] \SQL_DATA\MSSQL\BACKUP\isi.sqb ...
Processed 152 pages for database 'isi', file 'ISI_dat' on file 1.
Processed 1 pages for database 'isi', file 'ISI_log' on file 1.
BACKUP DATABASE successfully processed 153 pages in 0.144 seconds (8.654 MB/sec).
=========
Is there a solution? / comments
That's it - well almost. I see the NOWRITE option causes the backup file to not be created.
This hung:
master..sqlbackup '-sql "BACKUP DATABASE isi TO DISK = [D:\SQL_DATA\MSSQL\BACKUP\isi.sqb] WIT...
The backup issued via QA does show in the Backup History tab of the GUI, although the process does not finish. / comments
The backup issued via QA does show in the Backup History tab of the GUI, although the process does not finish.
I was incorrect when I said the command line also hung - I meant the stored procedure hung. I just tried the command line and it ran fine, but the stored procedure still does not stop in QA, and as a job it continues to say Executing Job Step '1 (Backup)'.
C:\Program Files\Red Gate\SQL Backup>sqlbackupc -SQL "BACKUP DATABASE [ISI] TO D
ISK = 'D:\SQL_DATA\MSSQL\BACKUP\<AUTO>'" -E
SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
Serial number: <removed>
Backing up ISI (full database) to [image] \SQL_DATA\MSSQL\BACKUP\FULL_(local)_ISI_2005
0628 105414.sqb ...
Backup data size : 1.875 MB
Compressed data size: 198.500 KB
Compression rate : 89.66%
Process completed successfully.
Processed 152 pages for database 'ISI', file 'ISI_dat' on file 1.
Processed 1 pages for database 'ISI', file 'ISI_log' on file 1.
BACKUP DATABASE successfully processed 153 pages in 0.129 seconds (9.660 MB/sec)
.
(1 row affected) / comments
I was incorrect when I said the command line also hung - I meant the stored procedure hung. I just tried the command line and it ran fine, but the stored procedure still does not stop in QA, and a...
It immediately returns to the prompt. It also does not create a log file in c:\program files\red gate\sql backup\ but the SQL Server functional account has full access to that folder. / comments
It immediately returns to the prompt. It also does not create a log file in c:\program files\red gate\sql backup\ but the SQL Server functional account has full access to that folder.
I just noticed that, although there isn't a log file created in c:\program files\red gate\sql backup\ , when I start the GUI the Activity Log shows the backups I did via command line, but not the ones via QA. / comments
I just noticed that, although there isn't a log file created in c:\program files\red gate\sql backup\ , when I start the GUI the Activity Log shows the backups I did via command line, but not the o...
I got this from running this command from QA:
master..sqlbackup '-SQL "RESTORE SQBHEADERONLY FROM DISK = [d:\sql_data\MSSQL\BACKUP\FULL_(local)_ISI_20050613 093646.sqb]" '
==============
SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
Trial - 2 days remaining
Reading SQB file header of "d:\sql_data\MSSQL\BACKUP\FULL_(local)_ISI_20050613 093646.sqb"
Backup group ID : 149794717
File number : 1 of 1
Backup type : 1 (Database)
Backup size : 1.875 MB
Backup start : Monday, June 13, 2005 9:36:52 AM
Backup end : Monday, June 13, 2005 9:36:53 AM
Server name : MARLIN
Instance : (local)
Database name : ISI
First LSN : 18000000077600001
Last LSN : 18000000077800001
Checkpoint LSN : 18000000077600002
Differential base LSN : 18000000077100003
================
Then I ran this from QA and it would never finish.
master..sqlbackup '-SQL "BACKUP DATABASE [ISI] TO DISK = [d:\sql_data\MSSQL\BACKUP\<AUTO>]" -E' / comments
I got this from running this command from QA:
master..sqlbackup '-SQL "RESTORE SQBHEADERONLY FROM DISK = [d:\sql_data\MSSQL\BACKUP\FULL_(local)_ISI_20050613 093646.sqb]" '
==============
SQL Backup...
This is the entire contents of the log file - after I ran both the GUI and the command line.
6/13/2005 7:48:20 AM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
6/13/2005 7:48:20 AM:
I don't receive an error any longer, just the process never ends when ran command line, but finishes in two seconds using the GUI. / comments
This is the entire contents of the log file - after I ran both the GUI and the command line.
6/13/2005 7:48:20 AM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
6/13/2005 7:48:20 AM:
I d...
Thanks, it was hanging before I added the LOGTO and is still hanging with the new version. Does it not always try to write to C:\Program Files\Red Gate\SQL Backup\ even when using LOGTO? And the docs say that -E is the default if it is not specified. / comments
Thanks, it was hanging before I added the LOGTO and is still hanging with the new version. Does it not always try to write to C:\Program Files\Red Gate\SQL Backup\ even when using LOGTO? And the ...
I've cleared up the log file error, but still cannot get the process to end. Backing up this database from the GUI takes about two seconds, but issuing this command from QA or a scheduled job will cause it to sit for hours - until I cancel it. The .sqb file DOES get created.
The log file is empty, no matter if I run from GUI or command line.
6/13/2005 7:48:20 AM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
6/13/2005 7:48:20 AM: / comments
I've cleared up the log file error, but still cannot get the process to end. Backing up this database from the GUI takes about two seconds, but issuing this command from QA or a scheduled job wil...