MSSQL database save

I have no knowledge of MS SQL whatsoever. I have an MSSQL database in a hosing package that I wish to close but before doing that I wish to download the database. Unlike My Sql, MSSQL doesn't allow Save As for the file. So I have downloaded Microsoft SQL Server Import and Export Data 2014 but don't know how to manage it to perform the operation importing the data into my hard drive.

Here's the iterface I should use.
SQL Server Import Export Wizard
Here's the data available I have through my hosting CP.
Hosting Control Panel
Nicola SiottoDirectorAsked:
Who is Participating?
 
Haris DulicCommented:
Hi,

can you provide info which hosting you are using? All hosting companies provide option to backup database and for MSSQL backup is enough to restore the database.

You can download MS SQl express edition and then import the export in order to test your back i.e. does it contains all the data..
0
 
Nicola SiottoDirectorAuthor Commented:
ix web hosting
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Deepak ChauhanSQL Server DBACommented:
If you are going to shut down the database, I would suggest take the database backup instead of downloading data. You can restore this backup whenever require in the future. If your requirement is saving the data in file format then you can use import and export data wizard (inbuild tool in MS sql server).

You have three option:
1.Backup database and copy to any safe location --( you can restore this backup when ever require)
2 Copy the .MDF and .LDF files of the database to any safelocation.  -- (you can attach these files when require)
3 save the data in the text or CSV files on disk.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
nsiotto, do you still need help with this question?
0
 
Nicola SiottoDirectorAuthor Commented:
Yes I still do need help with this.

The only solution that I am following is https://mlb.ixwebhosting.com but trying to login it takes forever. Maybe just some server issues so I am trying every now and then. Will keep posted in case of success.

I have downloaded MSSQL Server 2014 but don't know how to use it and have attempted several ways and it didn't work.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you try to contact the hosting company to help you on this?
They may perform a copy of the database and deliver it to you.
0
 
Nicola SiottoDirectorAuthor Commented:
The solution finally worked. I was just misled by login infos from the control panel. Once I had put the right info it worked allright. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.