October 6, 2004 at 11:37 am
Can anyone please let me know where in sqlserver is the path and file name of backups stored ? ANy help will be greatly appreciated.
TIA
October 6, 2004 at 12:49 pm
Look in the backupmediafamily table in msdb.
Greg
Greg
October 6, 2004 at 1:07 pm
On my servers the only reference to backup locations is on the SQL Agent job itself. Backup database 'databasename' to disk='backup location and file here' with init.
October 6, 2004 at 3:19 pm
select database_name,physical_device_name,backup_start_date,backup_finish_date from msdb..backupmediafamily a join msdb..backupset b on a.media_set_id = b.media_set_id where backup_start_date > '2004-10-06'
October 7, 2004 at 9:52 pm
If you are looking for the backup directory registry setting it is located under:
HKEY_LOCAL_MACHINE
\SOFTWARE
\Microsoft
\MSSQLServer
\MSSQLServer (or your instance name)
BackupDirectory
It defaults to being the \BACKUP directory under your SQL Server install path.
To see the locations of backups already performed: msdb..backupmediasets and the other backup tables hold the history.
Julian Kuiters
juliankuiters.id.au
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply