0

enter image description here

When I'm restoring a database, it is auto populating the original file name and restore as.

The check box (relocate all files to folder) is to change the destination path.

No matter if this checkbox is selected or not, the restore as default value is the same.

Is the default value for the relocate setting, and the Restore As value same as the default data and log file locations configured on the sql server?

1 Answer 1

0

The default location for Restore As is just the original location for the file, which is stored inside the backup file, as part of the headers for each database file that was backed up.

You can see this using the RESTORE FILELISTONLY command. Look at the LogicalName and PhysicalName columns. Use the WITH FILE = number parameter to specify which file you want.

LogicalName PhysicalName Type FileGroupName Size MaxSize FileId CreateLSN DropLSN UniqueId ReadOnlyLSN ReadWriteLSN BackupSizeInBytes SourceBlockSize FileGroupId LogGroupGUID DifferentialBaseLSN DifferentialBaseGUID IsReadOnly IsPresent
AdventureWorks_Data C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf D PRIMARY 202113024 3.51844E+13 1 0 0 50A534B0-156C-42B7-82FE-A57D21A53EEA 0 0 177012736 512 1 NULL 0 00000000-0000-0000-0000-000000000000 0 1
2
  • So the path comes from backup file, and the new database name is amended in the path by this UI?
    – variable
    Jun 4, 2023 at 2:49
  • Yes I think that's how it works Jun 4, 2023 at 2:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.