Kuidas parandada vigast SQL andmbaasi


Kasutada juhul kui andmebaasil on küljes tunnus (suspect)

1. Avada Micrsoft SQL Server Management Studio
2. Vajutada New Query
3. Kopeerida järgmised käsud ja asendada [YourDatabase] soovitud andmebaasi nimega

EXEC sp_resetstatus [YourDatabase];

ALTER DATABASE [YourDatabase] SET EMERGENCY

DBCC checkdb([YourDatabase])

ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [YourDatabase] SET MULTI_USER

4. Vajutada Execute




  Last Updated: 23.11.2021 | © Vallaste ja Partnerid OÜ, 2023