Activity overview
Latest activity by Ulfius
This fixed the problem. I believe since my SQL Server service account is a domain account and not a local account, it could not read the key. / comments
This fixed the problem. I believe since my SQL Server service account is a domain account and not a local account, it could not read the key.
MAILTO via stored procedure
Using this command via QA, I'm receiving error 150: SMTP host name not defined. The same command via sqlbackupc and the SMTP test in the GUI work fine.
master..sqlbackup '-SQL "BACKUP DATABASE [IS...
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 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...
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 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...
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...