Skip to content
  • Home
  • About
  • Blog
  • Contact
  • Oracle
  • SQL Server
  • MongoDB
  • Home
  • About
  • Blog
  • Contact
  • Oracle
  • SQL Server
  • MongoDB

Recovery state in restores

Restore database using T-SQL

USE [master]
RESTORE DATABASE [BackupDatabase] 
FROM  DISK = N'C:\FullBackups\BackupDatabase.bak' 
WITH  FILE = 1,  
NORECOVERY,  
NOUNLOAD,  
STATS = 5

RESTORE DATABASE [BackupDatabase] 
FROM  DISK = N'C:\FullBackups\BackupDatabase.bak' 
WITH  FILE = 7,  
NORECOVERY,  
NOUNLOAD,  
STATS = 5

RESTORE LOG [BackupDatabase] 
FROM  DISK = N'C:\FullBackups\BackupDatabase.bak' 
WITH  FILE = 8,  
NOUNLOAD,  
STATS = 5

GO

Top 50 SQL Blog
  • SQL Server In-Memory OLTP Overview -2
  • SQL Server In-Memory OLTP Overview – 1
  • SQL Server Cardinality Estimation
  • SQL Server Automatic tuning
  • SQL Server Statistics
  • SQL Server Resource Governor
  • Upgrading Databases using Query Tuning Assistant
  • Using SQL Server Management Studio
  • Partitioned Tables and Indexes
  • SQL Server Execution Plans
  • Database Engine Tuning Advisor
  • Intelligent query processing in SQL databases
  • Top Reasons for Slow Performance
  • SQL Server 2019 Performance Tuning
  • Security features of SQL Server on Linux
  • High availability for SQL Server containers
  • Troubleshoot SQL Server on Linux
  • SQL Server Replication on Linux
  • Performance best practices for SQL Server on Linux
  • Upgrade Availability Groups on Linux
  • Always On Availability Group on Linux
  • Availability Group Configurations
  • Always On Availability Groups on Linux
  • Failover Cluster Instances – SQL Server on Linux
  • SQL Server on Linux VDI client SDK Specification
  • Twitter
  • Facebook
  • Instagram
  • Pinterest
  • RSS
© 2020 iSqlPlus - All Rights Reserved.