Restore SQL Server database in same SQL server with different name
来源:互联网 发布:python 打开文件夹 编辑:程序博客网 时间:2024/04/30 15:40
Description :
I have an existing database called ABC, and I have a DB backup file (ABC_20140206.bak) of ABC a few months back.
Now, I need to restore the backup file to same SQL server for some data comparison.
How to restore the database without overwriting the existing one?
http://stackoverflow.com/questions/5228597/restore-sql-server-database-in-same-pc-with-different-name
http://stackoverflow.com/questions/6267273/how-to-restore-to-a-different-database-in-sql-server?lq=1
Steps to do :
1.In SQL Server Management Studio, right click the existing database and Rename ABC to ABC_Orig (to avoid overwriting)
(Without renaming the database, the existing database will be impacted although the new restoration is successful )
2.Then in SQL Server Management Studio, to restore the backup file, by allocating new database file name
3.Once restoration is successful, change back the rename the database name ABC_Orig back to ABC.
- Restore SQL Server database in same SQL server with different name
- How to backup and restore database in SQL Server
- Microsoft SQL Server Management Studio -- Restore database in a difference server
- how the same name folder with different case on linux server are displayed on windows server
- Different ranking function in SQL Server
- RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
- RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
- How to get the SQL Server name (Database server)?
- Database Mail in SQL Server 2005
- Database Mirroring in SQL Server 2008
- Accessing SQL Server Database in Editable GridView
- Image store in SQL-Server 2005 database and retrieve it in asp.net application with C#:
- Telerik RadScheduler Bind to SQL Server With Different Resource
- SQL Server backup and restore
- SQL Server system database
- SQL Server CE Database Development with the .NET Compact Framework
- sql server BACKUP LOG database WITH NO_LOG Clean log
- SQL Server中,用Restore DataBase把数据库还原到指定的路径
- Leftmost Digit
- JAVA 图形界面swing 创建按钮、文本域
- (Java)字符串处理--equals()和equalsIgnoreCase()
- sidekiq在 Plain Ruby 项目中的使用
- 为什么默认实参总是放在函数声明中
- Restore SQL Server database in same SQL server with different name
- 如何确定抽样统计的最小样本量(附:随机抽样统计的抽样误差Excel计算表格)
- UVA 216 - Getting in Line
- email正则表达式
- Java实现 输出 任意两个数之间的斐波那契序列
- 菜鸟的安卓实习之路----解析网络XML文件
- 使用vs为按钮添加后台点击事件
- 如何确定抽样统计的最小样本量(附:随机抽样统计的抽样误差Excel计算表格)
- Java设计模式透析之 —— 单例(Singleton)