Restore detached databases, & files not local to a SQLServer
I try to Browse to the backup files so I can restore them, but SQL Backup 4 only lets me browse file systems on registered SQL Servers. And it only lets me browse physical drives, not network drives. Wouldn't it make sense here to let me browse to any valid UNC path?
So how do I restore from, for example, network attached storage (which is where we keep all our backups) when the database is detached?
In SQL Server I would do this using RESTORE WITH REPLACE. Assuming I can get to the backup file (see above), will Red-Gate SQL Backup 4.0 let me restore a database that is detached? Is this where 'Scripts' come in - do I need to edit the Restore Script T-SQL before executing?
Anyway I'm just posting this for the benefit of others. I need to figure it out one way or another tonight, because I've taken an RG Backup of 2 databases, detached them and deleted the files! (Space is critical on the server I'm rescuing).
Hope I didn't just make a bad situation worse...