How can i take back up of a data basewith out having any machine/system specific data in the .bak file?
What are you trying to accomplish? You can obviously move a database backup file from one machine to another.
|||then why i cant restore a db ,in another system
i am getting error like
System.Data.SqlClient.SqlError:Directory lookup for the file "D:\Microsoft SQL Server2005\mydatabase.mdf" failed with the operating system error 2(Thesystem cannot find the file specified.). (Microsoft.SqlServer.Smo)
i am trying to restore from a .bak file
where d:is the place where sql server is installed in my system
and and in another system it is in c:
|||Yes, the path to the data and log files is stored with the backup. This is for convenience when you are restoring a backup to the same machine from which it was taken. Unfortunately it is inconvenient when moving to another machine. It the restore database dialog, you have to find the options for where to store the data and transaction log files. Modify these settings to fit the local machine. If you need more specific details, please indicate which version of Sql Server you are using.
Hope this helps,
Matt
|||
i am using sql server 2005
|||
in the restore window, after adding the backup file, go to the "options" page and change the two paths for .mdf and and .ldf files
No comments:
Post a Comment