Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kappa02
Yak Posting Veteran
65 Posts |
 Posted - 2014-03-11 : 14:53:15
|
| By querying these two tables you can find out when a backup was done and where, the question I have is if you don't see a physical path/Device Name (i.e D:\\Progam Files\Microsoft SQL Server\....) but instead see something like {6EC034-4560-1178....} is that telling me this is a temporay location where the backup is, And am I able to get to it, And can I use it to do a restore or create a new database Also is it automatically deleted after a certain period? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-03-11 : 15:05:02
|
| What does device_type equal for those with the GUIDS for physical_device_name?For the data to be deleted, you have run to periodically run sp_delete_backuphistory. We run it in an agent job weekly.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
kappa02
Yak Posting Veteran
65 Posts |
Posted - 2014-03-11 : 15:21:26
|
| The device type is 7 for the ones that have a path name of {6EC034-4560-1178.....}and the device type is 2 for the ones with a path of D:\\Program Files................I don't want to delete the data, I want to know if I can do a restore (get to) or create a database on the ones that are {6EC034-4560-1178.......} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-03-11 : 15:58:54
|
| I suspect it's Netbackup then. Yes you can restore from Netbackup. You can't do it with the normal restore command though.I would highly recommend that you do not use both Netbackup and native BACKUP commands. Do one or the other. If you do both and aren't using SIMPLE recovery model, your tlog chain backups will need to be recovered from both systems.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-03-11 : 15:59:39
|
| Most will recommend native backups and then sweeping those bak/trn files to tape using Netbackup. That's what we do.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
backupmediafamily & backupset system tables