DEFINITIONS

Definitions More Info.
Definition ID905
TitleSQL
CategoryNOTES
DefinitionFarkli isimde veritabani ATTACH etmek
Definition Descriptionhttps://dba.stackexchange.com/questions/24610/create-a-copy-of-db-and-renaming-it-so-i-can-attach-both-db/24766

USE [master]
GO
CREATE DATABASE [TEST1] ON
( FILENAME = N'E:\testdb\TEST1.mdf' ),
( FILENAME = N'E:\testdb\TEST1_log.ldf' )
FOR ATTACH
GO

USE [TEST1]
GO
ALTER DATABASE [TEST1]
MODIFY FILE (NAME=N'test', NEWNAME=N'TEST1')
GO
ALTER DATABASE [TEST1]
MODIFY FILE (NAME=N'test_log', NEWNAME=N'TEST1_log')
GO
RecordBycunay
Record Date20-12-2018 11:20:34
Düzenle
Kopyala
Sil