-- Database 분리하기
/*
EXEC sp_detach_db glonets
*/

-- Database 연결하기
/*
EXEC sp_attach_db @dbname = N'GLONETS',
   @filename1 = N'C:\uniLITE5\DataBase\GLONETS.MDF',
   @filename2 = N'C:\uniLITE5\DataBase\GLONETS_LOG.LDF'
*/

-- 응급복구모드를 통하여 복원하기
/*
CREATE DATABASE GLONETS
go
sp_configure 'allow updates', 1
go
reconfigure with override
go
UPDATE SYSDATABASES SET STATUS=STATUS|32768 WHERE NAME ='GLONETS'
go
DBCC REBUILD_LOG('GLONETS', 'C:\Program Files\Microsoft SQL Server\MSSQL\data\GLONETS_LOG.LDF')
go
UPDATE SYSDATABASES SET STATUS=24 WHERE NAME ='GLONETS'
go
sp_configure 'allow updates', 0 
go
reconfigure with override
go
*/

-- 자세한 내용은 아래에서 확인해주세요
-- http://faq.hostway.co.kr/zbxe/698

+ Recent posts