CODEWITHSUNDEEP
sql-serverdatabasevisual-studio-2010shared-hosting
Sergej Popov
Sergej Popov

Reputation: 3021

Moving SQL Server database to shared hosting using backup

I need to move my SQL Server database to shared hosting. Is there a tool there that allows me to import a database backup file? I'm stuck with actually making .bak file.

Its suggested that I use SQL Server Management Studio (SSMS), I tried downloading it from here, but failed to install.

I found I could run a query like

BACKUP DATABASE mydbname TO disk = 'd:\bak'

but can't figure out where I do this in VS 2010.

I'm stuck on this lame problem, please give me a hint.

Upvotes: -1

Views: 320

Answers (2)

Sergej Popov
Sergej Popov

Reputation: 3021

Resolved: I found this detailed tutorial on how to install SSMS here.

Then I used following query to make backup:

 BACKUP DATABASE mydbname TO disk = 'd:\bak'

Upvotes: 0

Steve
Steve

Reputation: 216313

This little utility could be your solution, it's free for any manually backups.

SQLBackupAndFTP

However, remember that a SQLServer backup could be restored only on the same or subsequent versions of SQLServer

Upvotes: 2

Related Questions