Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. SQL Server Manageability. Sign in to vote. Tuesday, November 13, PM. Privacy policy. Associating file extensions to a specific code editor allows you to open a file with the appropriate SQL Server Management Studio code editor when you double-click a file in Windows Explorer.
The extensions commonly used by Management Studio, such as. New file extensions must also be associated to Management Studio in the file system. You can use this feature to open files created with other editors, or to open files you have renamed, such as backups of. On live, I did a "backup database". When complete, I copied that file to the backup directory on the test server. Then I performed a "restore database" from device, navigate to that backup file.
IF NOT If you are using the Restore wizard, you need to change the file path on the Options tab of the wizard. Change the path in the "Move to physical file name" option to the desired location. Which leads me to ask, are you using 2 different versions of SQL Server like 7 and between your machines?
The location for the log file was different. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. In the table that appears, find the column Restore As.
In each row, give a new file name, instead of the name that shows. Give a different name other than Tes. A name that does not already exist in the DATA folder. Note: The file names do not have anything to do with the database name, but it will easy referencing later on to give a meaningful name, in case you have to backup or look for the files.
If you are trying to move your database to a new location, you should better detach the source database or take it offline first. The issue was that the database backup file that I was using for this database restore operation had been previously used to restore data to a different database on the same server.
All I had to do was to change the Physical names of the Logical files to that of the database that I was to restore to. That is from com. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.
0コメント