Error - Exclusive access could not be obtained because the database is in use

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  March 5, 2014 at 4:27 pm

  #286316

  I am actually trying to make a script (in Sql Server 2008) to restore one database from one backup file. I made the following code and I am getting an error -

  Msg 3101, Level 16, State 1, Line 3

  Exclusive access could not be obtained because

  the database is in use.

  Msg 3013, Level 16, State 1, Line 3

  RESTORE DATABASE is terminating abnormally.

  How do I fix this problem ?

  IF DB_ID('AdventureWorksDW') IS NOT NULL

  BEGIN

  RESTORE DATABASE [AdventureWorksDW]

  FILE = N'AdventureWorksDW_Data'

  FROM

  DISK = N'C:\Program Files\Microsoft SQL Server\

  MSSQL10_50.SS2008\MSSQL\Backup\AdventureWorksDW.bak'

  WITH FILE = 1,

  MOVE N'AdventureWorksDW_Data'

  TO N'C:\Program Files\Microsoft SQL Server\

  MSSQL10_50.SS2008\MSSQL\DATA\AdventureWorksDW.mdf',

  MOVE N'AdventureWorksDW_Log'

  TO N'C:\Program Files\Microsoft SQL Server\

  MSSQL10_50.SS2008\MSSQL\DATA\AdventureWorksDW_0.LDF',

  NOUNLOAD, STATS = 10

  END

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  March 5, 2014 at 6:39 pm

  #1694531

  Try this ..

  http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/

  --

  SQLBuddy