mdf den db kurtarma

EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\mssql7\data\pubs.mdf',
@filename2 = N'c:\mssql7\data\pubs_log.ldf'

sonra
burda da db yi single user moda aldım da satırı unuttum
use master
go
spdboptions 'dbadi','single user','true' gibi biseydi
go
DBCC CHECKDB ('db_Adi',REPAIR_REBUILD)
go

aslinda mdf saglam olsa son check islemine gerek kalmazdi heral ama neyse bi nebze kurtuldu oteside allah kerim :)

Comments

Popular posts from this blog

Postgresql group by day, week and month examples

Next (2007)

Spring-boot vs Quarkus