question regarding to SQL SERVER
-
1)How to make (.mdf) file in Sql Server (use to deploy database on other computer) Actually i want to deploy my SQL database along with its data to other computer EsHbAn BaHaDuR
Make a backup of the database and restore it on the new computer.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
Make a backup of the database and restore it on the new computer.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
Would be best to attach and detach http://www.databasejournal.com/features/mssql/article.php/2224361[^]
si_69 wrote: Would be best to attach and detach May I ask why? The article you link to does at least tell the user how to get round the main problem of detaching and reattaching (loss of users - which is because the logins are stored in the Master database and referenced in the individual databases and the uids may be different across servers). However, I've never had that problem with restoring a backup.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
si_69 wrote: Would be best to attach and detach May I ask why? The article you link to does at least tell the user how to get round the main problem of detaching and reattaching (loss of users - which is because the logins are stored in the Master database and referenced in the individual databases and the uids may be different across servers). However, I've never had that problem with restoring a backup.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
Colin Angus Mackay wrote: May I ask why? minimal downtime and no data loss,it is best to move it by detaching and then reattaching the database on the new server. The database will be offline during the move but it is better to have it offline than to miss transactions when backing up and then restoring the database on the new server.