Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Takeshi
Starting Member
2 Posts |
 Posted - 2013-10-17 : 12:02:32
|
| Hi all,I have created a database in Sql Server Management Studio (SSMS) but I do not know how can I get it from it. When I try to copy it to anohter folder it write me sth like "it is open in SSMS" ... thank you all for answer |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-17 : 12:30:14
|
| I suspect you are trying to manage it contrary to what the recommendations are. When you create a database, the process creates data files and log files, but it also creates entries in the meta data tables of SQL Server. So trying to copy/open/work with the raw data files on the OS would not be a good idea.If you want to make a copy of the database, the recommended way is to go to SSMS, backup the database (right click on the database name in object explorer) which will produce a single backup file, take that backup file and restore (right click on the server name in SSMS to get restore menu) it to where you want it to go. The dialogs that popup will give you all the options/choices that you will need to manage the database. |
 |
|
|
Takeshi
Starting Member
2 Posts |
Posted - 2013-10-17 : 13:07:03
|
| Thanks |
|
|
|
|
|
|
SSMS create database