• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

MS SQL Backup DB locally

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
cuadmin
Asked:
cuadmin
3 Solutions
 
TechieMDCommented:
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
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
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
 
lcohanDatabase AnalystCommented:
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
 
cuadminAuthor Commented:
Thanks everyone - it looks like Generate Scripts and Exporting Data will work just fine!

Thanks!

E.D.
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now