Home Forums SQL Server 2016 SQL Server 2016 - Administration Restore database with Attach RE: Restore database with Attach

  • February 9, 2018 at 3:25 am

    #1979204

    John Mitchell-245523 - Friday, February 9, 2018 2:35 AM

    Did you do what it suggested in the error message?  

    I try use this, but SQL [Could not find stored procedure 'sp_dboption']
    use master 
    declare @databasename varchar(255)
    set @databasename='MyDatabase.mdf'
    exec sp_dboption @databasename, N'single', N'true' 
    dbcc checkdb(@databasename,REPAIR_ALLOW_DATA_LOSS)
    dbcc checkdb(@databasename,REPAIR_REBUILD)
    exec sp_dboption @databasename, N'single', N'false'