Portabling SQL database from one system to another
|
|
|
Question / Problem
|
problem:transferring database from one system to another system if you not configured properly the database cannot be opened
|
Solution
|
Solution:
1.while copying the data base file from one system to another first you may stop the server then take the backup files
2.The copied backup file are store on the data base directory by browsing the .mdf file and log file
3.If you connecting the database to vb.net or asp.net we must changed the name of the data source with current working system name
4.Backup method must use in any system failure or software failure
These are the important method while backup from one database system to another system
|
Applies to |
|
Microsoft SQL Server 2005
,Microsoft SQL Server 2000
|
Rank It |
|
