Solved

Azure SQL Server Migration Assistant

Posted on 2016-10-13
4
18 Views
Last Modified: 2016-10-23
I need to do a backup from a remote sqlserver database to my local PC.

I have full access and rights... just no RDP.

I understand Azure SQL Migration Assistant is the answer?

Where can I download that?
0
Comment
Question by:lrbrister
  • 3
4 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 41842062
Can that " remote sqlserver database" and your "local PC." access some common network share? If yes that's how you can take a SQL FULL backup onto that share then restore it from the share or copy the backup to your PC.
0
 

Author Comment

by:lrbrister
ID: 41843010
No
There are no shared drives or network
0
 

Accepted Solution

by:
lrbrister earned 0 total points
ID: 41848566
Found my own solution with SQL Accessories
0
 

Author Closing Comment

by:lrbrister
ID: 41855869
I found my own solution elsewhere
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now