1

I am running win7 on a VM. I have Microsoft SQL Server 2014 downloaded on the VM. I have an external drive with a .bak file that I wish to restore a database with. The database is 400+ GBs. My local disk cannot support a database of this size, but my external drive can. How do I run SQL Server locally and restore from and keep the database files externally?

Improve this question

2 Answers 2

Reset to default
0

You can create database then configure it for files run on external drive. Then try to restore it. Creating db on another folder example here: Create a database using T SQL on a specified location

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

I am sorry I am such a beginner, but where am I writing the code do these things? Where are those files located? Its not all in the command line, is it?
you can run command in sqlcmd.exe or you can use any db managament tools (sql management studio, navicat, toad, etc)
0

It's possible, search for DBCC TRACEOFF(1807), e. g.:

http://sql-articles.com/articles/general/day-2trace-flag-1807attach-network-data-file/

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.