Ȩ
ȣ
()
(ű)
/û
FAQ
ٶ
070-8260-2526
9 ~ 6
352-0331-1626-83
:ũڸ
ֹ
Ȩ > > ֹ
ȸ
7374
̿ ο ̸ ͺ̽
̿ ο ̸ ͺ̽ | MSSQL
2011.01.02 18:56
Ӹ
dongwoonseo
http://cafe.naver.com/softvil/90
USE master
GO
-- Ʈ Logical Name Ѵ
RESTORE FILELISTONLY FROM DISK = 'E:mssql_backupbackup-20101112.bak'
-- ̱ Ͽ
ALTER DATABASE user_dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
-- (ο ̸ ͺ̽ , ͺ̽ ڵ )
restore database user_dbname from disk='E:mssql_backupbackup-20101112.bak' with recovery,
move 'dbname' TO 'C:Program FilesMicrosoft SQL ServerMSSQL$SVSQLDatauser_dbname_DATA.MDF',
move 'dbname' TO 'C:Program FilesMicrosoft SQL ServerMSSQL$SVSQLDatauser_dbname_LOG.MDF',
REPLACE
GO
-- Ƽ
ALTER database user_dbname SET MULTI_USER
GO
-- ͺ̽ ̾ ܵ ϴ. ̱ ذ
SQL â ϰ δ PATH.
[ó] ̿ ο ̸ ͺ̽ (ĵ - ()Ʈ) |ۼ dongwoonseo
ֹ
¶λ
Ʈ