Syntaxes for Restore

 restore filelistonly from disk = 'E:\RAVIDBA\FULL\AdventureWorks2012_full_backup_20210529_120800.bak'


select * from sys.sysaltfiles


restore database [AdventureWorks2012] 

from disk = 'E:\RAVIDBA\FULL\AdventureWorks2012_full_backup_20210529_120800.bak' 

with replace , recovery ;


restore database [RAVIDBA] 

from disk ='E:\RAVIDBA\FULL\AdventureWorks2012_full_backup_20210529_120800.bak'

with

move 'AdventureWorks2012' 

to 'D:\MYSQLSERVER\MSSQL11.RAVISQLSERVERDBA\MSSQL\DATA\RAVIDBA.mdf', 

move 'AdventureWorks2012_log' 

to 'D:\MYSQLSERVER\MSSQL11.RAVISQLSERVERDBA\MSSQL\LogDB\RAVIDBA_log.ldf' , replace, recovery , stats = 5 ;

Comments

Post a Comment

Popular posts from this blog

CREATE VIEW SQL: Modifying views in SQL Server

Image
Introduction The primary goal will be to get familiar with the  ALTER VIEW  command used to modify views and change the output. A view is based on the result set from a query, and this command allows us to change the structure and definition of a query. Ironically, before modifying a view, we will create another view with a bit more complex T-SQL using aggregates in it rather than having a simple SELECT statement that is pulling everything from a table. We will not go over the syntax again since T-SQL is exactly the same as in CREATE VIEW SQL statement except the fact that instead of the CREATE reserved keyword ALTER is used. Creating view As I mentioned earlier, let’s use the code from below to create a bit more complex view: 1 2 3 4 5 6 7 8 9 10 11 CREATE VIEW vTop3SalesByQuantity AS      SELECT TOP 3 --will only return first 3 records from query      Sales . ProductID ,      Name AS ProductName ,      SUM ( Sales . Quantity ) AS TotalQuantity      FROM Sales            J
Read more

SQL SERVER –Different Ways to Find Recovery Model for Database

Image
  This is a very easy method and it gives all the database information in one script. SELECT  name  AS  [Database Name] , recovery_model_desc  AS  [Recovery Model]  FROM  sys.databases GO Method 4 This method provides only one database at a time. SELECT  'ADVENTUREWORKS'  AS  [Database Name] , DATABASEPROPERTYEX ( 'ADVENTUREWORKS' ,  'RECOVERY' ) AS  [Recovery Model] GO My recommendation
Read more