anargha
Reputation: 21
How to convert user instance database to normal sql server database
can anybody help me by providing a link on how to convert a user instance database to normal sql server database. Thanks in advance.
Upvotes: 0
Views: 404
Answers (1)
Andomar
Reputation: 238296
Copy the user instance MDF to a new directory. From SSMS, right click "Databases" and then Attach.
Upvotes: 0
Related Questions
- How to convert SDF file database to SqlServer Database
- How to transfer a database AND its users from one SQL Server to another?
- How to change database from Single user mode to multi user
- how to Create SQL Server Database with User?
- Backward Converting SQL Databases
- Moving a SQL Server database from Visual Studio to SQL Server Manager
- Converting SQL Server Express To SQL Server?
- How to transfer the existing database users to a new ms sql server?
- How to convert a SQL Server database to other format so that I can deploy it without SQL Server service?
- Easy way to import/export Sql Server 2005 users/permissions across instances?