We have previously covered a simple SQL database restore using the command line which is ideal for restoring backup files created on the same SQL Server installation, however if you are restoring a backup created on a different installation or simply prefer a point and click interface, using SQL Server Management Studio (or the Express edition) makes this task easy.
之前,我们已经介绍了使用命令行进行简单SQL数据库还原的方法,该方法非常适合还原在同一SQL Server安装上创建的备份文件,但是,如果要还原在其他安装上创建的备份,或者只是更喜欢单击界面,则使用SQL Server Management Studio(或Express版)使此任务变得容易。
Note: SQL Server experts might want to skip today’s lesson, as it’s aimed at beginners.
注意:SQL Server专家针对初学者,可能希望跳过今天的课程。
Before starting, you will need to copy the SQL backup file (typically has a .BAK extension) to a local hard drive on the destination SQL Server machine.
开始之前,您需要将SQL备份文件(通常具有.BAK扩展名)复制到目标SQL Server计算机上的本地硬盘驱动器上。
Open SQL Server Management Studio and login to the SQL Server you want to restore the database to. It is best to either login as a Windows Administrator or as the SQL ‘sa’ user.
打开SQL Server Management Studio,然后登录到要将数据库还原到SQL Server。 最好以Windows管理员或SQL“ sa”用户身份登录。