June 19, 2014 at 5:39 pm
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.
June 19, 2014 at 6:03 pm
Why don't you create the DB on the cloud and restore it from a backup (which might be compressed if you're on 2008R2+). It seems safer than using mdf and ldf files.
June 19, 2014 at 9:09 pm
fkarmally (6/19/2014)
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.
You can't just copy the files and expect SQL to notice. You will need to attach the files to a (new) database. In SSMS, right click on "Databases" and select attach.
June 20, 2014 at 2:58 am
happycat59 (6/19/2014)
fkarmally (6/19/2014)
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.You can't just copy the files and expect SQL to notice. You will need to attach the files to a (new) database. In SSMS, right click on "Databases" and select attach.
Exactly!
The other way is to copy over a backup and restore that.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply