Mobile app version of vmapp.org
Login or Join
Dunderdale272

: Moving big database from one server to another I have created a website that I know that its database size will increase rapidly. It will become terabytes and by the way I don't want to get

@Dunderdale272

Posted in: #Database #Migration #SqlServer

I have created a website that I know that its database size will increase rapidly. It will become terabytes and by the way I don't want to get a expensive server at first. What is I'm concerned about:


If my cheep server is not enough, how do I move gigabytes of database to another server (considering that meanwhile the website will be in maintenance mode)
Is there any ways (any services) that I can have unlimited database size without worrying about database size and moving it?


PS: I'm using SQL server 2014.

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Dunderdale272

1 Comments

Sorted by latest first Latest Oldest Best

 

@Radia820

If you're talking about dedicated servers, then it won't be such a big problem to transfer the database.

You can use SSH in order to transfer it directly from one server to another, without even downloading it. Then you can import it in a new database from the command line pretty fast.

If you don't want to worry about storage and performances, then go for cloud hosting. There you can upgrade/downgrade your server on the run and even set up dedicated servers for your database only ( which is a really good idea ).

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme