Anonymous
Asked in
Cars &Transportation
·
2 weeks ago
How do I backup my SQL database to local drive?
Contents
- How do I export a SQL Server database to local machine?
- How do I backup my SQL database to an external drive?
How do I export a SQL Server database to local machine?
You can use Copy database ... right click on the remote database ... select tasks and use copy database ... it will asks you about source server and destination server . that your source is the remote and destination is your local instance of sql server. Copy database requires SysAdmin privileges.
How do I backup my SQL database to an external drive?
Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. In the Destination section of the General page, click Disk or Tape.
Related Questions
Relevance
-
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago
Write us your question, the answer will be received in 24 hours