---
title: "How to restore to a different database in sql server?"  
description: "How to restore to a different database in sql server?"  
author: "Anonymous User"  
published: 2015-09-08  
updated: 2015-09-08  
canonical: https://www.mindstick.com/forum/33447/how-to-restore-to-a-different-database-in-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to restore to a different database in sql server?

I have a [backup](https://www.mindstick.com/interview/1205/what-is-the-command-to-take-backup-and-restore-for-sharepoint-site) of Database1 from a week ago. The backup is done weekly in the scheduler and I get a .bak file. [Now](https://yourviews.mindstick.com/view/81402/it-s-liberals-vs-progressives-in-us-politics-now) I want to fiddle with some [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) so I need to [restore](https://yourviews.mindstick.com/story/1480/ways-to-restore-ecosystems-and-heal-the-planet) it to a different [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) - Database2.


---

Original Source: https://www.mindstick.com/forum/33447/how-to-restore-to-a-different-database-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.