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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicIT ArchitectCommented:
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
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
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Haris DulicIT ArchitectCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.