Comments
Sort by recent activity
+1 for a nice feature to have
It's funny, xSQL ScriptExecutor has 1 output log file
and people probably request 1 per script there :P / comments
+1 for a nice feature to have
It's funny, xSQL ScriptExecutor has 1 output log file
and people probably request 1 per script there :P
geller
Do you have anything else installed? SSMS Tools Pack or etc...
I'd uninstall SQL Prompt, restart, make sure SSMS works fine
re-install SQL Prompt again, and see how it works / comments
geller
Do you have anything else installed? SSMS Tools Pack or etc...
I'd uninstall SQL Prompt, restart, make sure SSMS works fine
re-install SQL Prompt again, and see how it works
Thanks Brian
User profile thing I understand
1. My A account has NOTHING in my SSMS though
yet I still see SOME servers from the import list
I also believe when you RUN AS ... another user (B), settings ARE stored under that user profile instead of your windows login account (A)
2. How do I dump the server list in SQL Backup Import?
That'd be easiest
3. How do I export & import SQL Backup servers/groups list? maybe to another SQL Backup location? / comments
Thanks Brian
User profile thing I understand
1. My A account has NOTHING in my SSMS though
yet I still see SOME servers from the import list
I also believe when you RUN AS ... another user (B), set...
So today I was testing it, and realized
I have both SSMS 2005 and SSMS 2008 installed
all servers are under the domain B account
and SQL Backup was Importing Servers from SSMS 2005 Registered Servers, NOT SSMS2008 ones.
It is doing it real-time too (I am running SSMS 2005 as account B, Delete a server, import server in SQL Backup, server is no longer listed)
I guess deciding whether to import from SSMS 2005 or 2008 is beyond SQL Backup's scope / comments
So today I was testing it, and realized
I have both SSMS 2005 and SSMS 2008 installed
all servers are under the domain B account
and SQL Backup was Importing Servers from SSMS 2005 Registered Serve...
Thanks, let me give it a try / comments
Thanks, let me give it a try
Never mind the issue
I re-downloaded a new backup (daily generated)
MD5 both and they matched
Restored with SQL Backup, it worked fine
Thanks / comments
Never mind the issue
I re-downloaded a new backup (daily generated)
MD5 both and they matched
Restored with SQL Backup, it worked fine
Thanks
petey wrote:
Could you please post the contents of the SQL Backup log file for the restore that failed? By default, the log files are stored in C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.
Does your SQL Server 2008 database use the new FILESTREAM feature?
Is the backup file the original backup file, or is it a copy? If the latter, could you please check if the file is identical to the original? You could use a md5 file hash generator to generate a checksum.
Here's the log file
SQL Backup log file 5.3.0.178
-SQL "RESTORE DATABASE [VerticalsLog] FROM DISK = 'D:\Backup\VerticalsLog.sqb' WITH RECOVERY, MOVE 'VerticalsLog' TO 'E:\SQLData\VerticalsLog.mdf', REPLACE "
ERRORS AND WARNINGS
10/3/2008 2:29:07 PM: Restoring VerticalsLog (database) from:
10/3/2008 2:29:07 PM: [image] \Backup\VerticalsLog.sqb
10/3/2008 2:29:07 PM: RESTORE DATABASE [VerticalsLog] FROM VIRTUAL_DEVICE = 'SQLBACKUP_570CC681-3C68-44F2-9870-E2005C474C68' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'VerticalsLog' TO 'E:\SQLData\VerticalsLog.mdf', REPLACE
10/3/2008 2:33:21 PM: Thread 0 error:
Data decompression error: ZLib decompression error: data error
Process terminated unexpectedly. Error code: -2139684860
10/3/2008 2:33:21 PM:
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3183: SQL error 3183: RESTORE detected an error on page (0:0) in database "VerticalsLog" as read from the backup set.
FILESTREAM is Disabled on both the Source server DB and the Destination server DB
The file is the original backup file downloaded via the FTP / comments
petey wrote:
Could you please post the contents of the SQL Backup log file for the restore that failed? By default, the log files are stored in C:\Documents and Settings\All Users\Application D...
That's what I do to restore our production .sqb files
on machines with SQL Backup, I use the
exec master..sqlbackup
on most of other machines I need to restore
I use sqb2mtf, works very well / comments
That's what I do to restore our production .sqb files
on machines with SQL Backup, I use the
exec master..sqlbackup
on most of other machines I need to restore
I use sqb2mtf, works very well
Interesting, because Database Mail goes through SMTP as well, no?
You can't simulate SQL Response as the DB mail account?
unless they block by IP, SMTP authentication should work with a set of username/password, and a valid FROM email address / comments
Interesting, because Database Mail goes through SMTP as well, no?
You can't simulate SQL Response as the DB mail account?
unless they block by IP, SMTP authentication should work with a set of user...
I am sure RedGate staff will get to you with a better answer
But there is a command argument to control how many files/days(?) to keep network backup files
and next version of SQL Backup GUI should have better "network" backup management as far as I recall reading on this forum / comments
I am sure RedGate staff will get to you with a better answer
But there is a command argument to control how many files/days(?) to keep network backup files
and next version of SQL Backup GUI should...