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 |
|
fredk
Starting Member
8 Posts |
 Posted - 2014-06-19 : 19:25:36
|
| I copied my mdf and ldf file to the cloud server, and the data path is correct. But the database does not show up in management studio. I have done this before between in house servers running SQL2008. Could it be ownership, permissions, or that the server has another name, or something else.? It is a big file (130GB) that takes 4 days to upload via RDP so I dont want to create a database on the cloud and then import it. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-19 : 19:38:37
|
| So you copied the files to the cloud server, but did you attach it? I have very minimal experience with cloud databases so I am not even sure that attach is the right step. I was shocked to hear that regular backups aren't supposed, so I won't be surprised if the normal copy/attach method is different.If you did attach, then I would suspect permissions.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
fredk
Starting Member
8 Posts |
Posted - 2014-06-19 : 19:49:35
|
| I cannot attach because it does not come in Management Studio. Is there another way to attach, besides right clicking and choosing all tasks and then attach/detach? What would I be looking for in permissions, I have given user and administrator full control. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQLServer wont recognize database