Solved

MS SQL Backup DB locally

Posted on 2016-09-01
4
67 Views
Last Modified: 2016-09-01
I have access to the database via Management studio only... is there a way I can backup the DB locally, to my workstation?

Thanks,

E.D.
0
Comment
Question by:edalzell01
4 Comments
 
LVL 5

Accepted Solution

by:
TechieMD earned 250 total points
Comment Utility
See this guide. It's not a true backup as it wouldn't include transaction logs and statistics, but it's the closest thing aside from doing a remote backup and having someone zip it up and send it to you.
1
 
LVL 11

Assisted Solution

by:Nakul Vachhrajani
Nakul Vachhrajani earned 125 total points
Comment Utility
What are your rights on the SQL server instance itself? (rights on the OS and on the instance are two different things)

I am trying to see if you can perform a remote backup using the BACKUP DATABASE T-SQL statement. (https://nakulvachhrajani.com/2012/06/21/0171-sql-server-scripts-backup-and-restore-a-database-over-a-network-using-unc-paths/)
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 125 total points
Comment Utility
OK you "...have access to the database via Management studio only"
From where you start SSMS? Local workstation?

"... is there a way I can backup the DB locally, to my workstation?" - most likely not directly but here are a few options depending on security/access/reach:

You could add a local share and make that share available to the SQL Server where that database is and initiate the backup to that share.

Vice-versa, if theres some SQL Server share that you can access from your workstation you can initiate the backup to that share and take it from there.

Do you have SQL installed locally and is it the same version? If you do then starting SQL 2012 there's a "Database Copy" functionality that will allow you to "copy" that database between the two.

https://msdn.microsoft.com/en-us/library/ms188664(v=sql.110).aspx
0
 

Author Comment

by:edalzell01
Comment Utility
Thanks everyone - it looks like Generate Scripts and Exporting Data will work just fine!

Thanks!

E.D.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

762 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

10 Experts available now in Live!

Get 1:1 Help Now