DEFINITIONS

Definitions More Info.
Definition ID820
TitleSQL
CategoryNOTES
DefinitionBasit Database RESTORE tek mdf ve ldf log dosyas
Definition Description-- Aşağıdaki örnek tek mdf ve tek ldf restore için
USE [master]
RESTORE DATABASE [AdventureWorks2014]
FROM
DISK = N'/storage/MSSQL/BACKUP/AdventureWorks2014BCK/AdventureWorks2014.bak' WITH FILE = 1,
MOVE N'AdventureWorks2014_Data' TO N'/storage/MSSQL/DATA/AdventureWorks2014/AdventureWorks2014_Data.mdf',
MOVE N'AdventureWorks2014_Log' TO N'/storage/MSSQL/LOG/AdventureWorks2014Log/AdventureWorks2014_Log.ldf',
RECOVERY,
NOUNLOAD,
STATS = 5
GO
RecordBycunay
Record Date10-12-2017 00:25:06
Düzenle
Kopyala
Sil