Comments
Sort by recent activity
Hold on, will I lose my snippets if I uninstall? / comments
Hold on, will I lose my snippets if I uninstall?
yet another post!
found the snippets via the Snippet Manager (Locate on Disk is a nice feature) here:
C:\Documents and Settings\allenj\Local Settings\Application Data\Red Gate\SQL Prompt 4 in the same level there is a Logs folder that has 3 folders - SQL Backup, SQL Object Level Recovery Pro 1 and SQL Response 1. Not sure how I missed these, I will have to ditch windows search index and get some other indexing tool... / comments
yet another post!
found the snippets via the Snippet Manager (Locate on Disk is a nice feature) here:
C:\Documents and Settings\allenj\Local Settings\Application Data\Red Gate\SQL Prompt 4 in the s...
Right.
Uninstalled.
Reinstalled.
Upgraded to 4.0.3.10
tried query
Select pr.knownas, pr.surname from personnel as pr inner join personnel as pr2 on
aaaand the system locks. After a few minutes you can get in to the SSMS UI and slowly step by step select the query and delete it and then all returns to normal but it is a slow process as you have to wait for a very delayed response.
It seems to be having trouble gathering all the join options. The table has 368 columns... could be a problem if its trying to provide the cross join of all of those as possibilities?
cheers
Jonathan / comments
Right.
Uninstalled.
Reinstalled.
Upgraded to 4.0.3.10
tried query
Select pr.knownas, pr.surname from personnel as pr inner join personnel as pr2 on
aaaand the system locks. After a few minutes you ...
no such folder :-/ / comments
no such folder :-/
Hi Brian,
I cant find any such folder I'm afraid ... I am on XP sp3 so checked C:\Documents and Settings\allenj\Application Data\Red Gate
and there are only SQL Backup, SQL Multi Script, SQL Refactor and SQL Response Client folders
and C:\Documents and Settings\All Users\Application Data\Red Gate
where there are Licences and SQL Search folders.
where else can I look? / comments
Hi Brian,
I cant find any such folder I'm afraid ... I am on XP sp3 so checkedC:\Documents and Settings\allenj\Application Data\Red Gate
and there are only SQL Backup, SQL Multi Script, SQL Refact...
Hi Brian,
There is no dialogue, it just stops. CPU trace shows 1 core dedicated 100% to SSMS and its unresponsive to everything but Task Manager.
I cant find any related entries in any log.
Jonathan / comments
Hi Brian,
There is no dialogue, it just stops. CPU trace shows 1 core dedicated 100% to SSMS and its unresponsive to everything but Task Manager.
I cant find any related entries in any log.
Jonathan
Pete, thanks for the prompt response.
We run trial restores of our backups on a development server and prefix the database names with "RESTORE_" so that we know which they are and can drop them safely once the restore is done.
It looks like I need the database rename part of one format and the 'cross server' ability to get to the network share of the other format!!
Oh well, I'll hang on for the full(er) functionality from the future release.
thanks again / comments
Pete, thanks for the prompt response.
We run trial restores of our backups on a development server and prefix the database names with "RESTORE_" so that we know which they are and can drop them saf...
This fails - with a remote share
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [Restore_Adventureworks] FROM DISK = [\\backup1\backups\sql\rutherford\rutherford_planck\adventureworks\FULL*.sqb] LATEST_FULL WITH RECOVERY, MOVE [AdventureWorks_Data] TO [C:\Program Files\Microsoft SQL Server\MSSQL10.PLANCK\MSSQL\Data\Restore_Adventureworks.mdf], MOVE [AdventureWorks_Log] TO [C:\Program Files\Microsoft SQL Server\MSSQL10.PLANCK\MSSQL\Data\Restore_Adventureworks_Log.ldf], ORPHAN_CHECK"'
This also fails - with a local file location
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [Restore_Adventureworks] FROM DISK = [D:\Test\FULL*.sqb] LATEST_FULL WITH RECOVERY, MOVE [AdventureWorks_Data] TO [C:\Program Files\Microsoft SQL Server\MSSQL10.PLANCK\MSSQL\Data\Restore_Adventureworks.mdf], MOVE [AdventureWorks_Log] TO [C:\Program Files\Microsoft SQL Server\MSSQL10.PLANCK\MSSQL\Data\Restore_Adventureworks_Log.ldf], ORPHAN_CHECK"'
they both give the same error message to I took that to mean the network share is a valid option... :-/
Both locations only had SQL Backup full backup files for the adventureworks database from the last 4 days. / comments
This fails - with a remote share
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [Restore_Adventureworks] FROM DISK = [\\backup1\backups\sql\rutherford\rutherford_planck\adventurework...
Peter, I have only now had a chance to try this out on our test rig and I am consistently getting the same error : Error 507: No valid backup sets found from provided folder(s).
I have tried from a local drive and a network location with no difference. Running the full SQL Backup script with the file name explicitly named works fine from both locations ... Can you give me any further advice please?
[Edit: I'm using v6.3.0.48]
[Edit 2: oddly, this works;] EXEC master..sqlbackup '-sql "RESTORE DATABASE [RESTORE_AdventureWorks] FROM BACKUPHISTORY = [adventureworks] LATEST_FULL with recovery ....
regards
Jonathan / comments
Peter, I have only now had a chance to try this out on our test rig and I am consistently getting the same error :Error 507: No valid backup sets found from provided folder(s).
I have tried from a ...
Nice call Jerry,
automated restores are something that I would love to see integrated into SQLBackup and being able to use these would be a good move towards it.
Jonathan / comments
Nice call Jerry,
automated restores are something that I would love to see integrated into SQLBackup and being able to use these would be a good move towards it.
Jonathan