Database Snapshot

create database OK
use OK

create table Mahasiswa
(
NPM varchar (10) primary key,
Nama varchar (30),
Alamat varchar (40)
)

insert into Mahasiswa values ('2010240333','Sukriyadi','Palembang')
insert into Mahasiswa values ('2010240334','Sukriy','Palembang')
insert into Mahasiswa values ('2010240335','Yadi','Palembang')

'Membuat Database Snapshot'
create database SnapS
on
(name = OK,
filename = 'd:\sukriyadi\mydata.ss')
as snapshot of OK;

-------------

create database OKlgSS on
(name=OKlg_dat,
filename = 'd:\sukriyadi\OKlg_dat.ss'),
(name=OKlg_dat1,
filename = 'd:\sukriyadi\OKlg_dat.ss'),
(name=OKlg_dat2,
filename = 'd:\sukriyadi\OKlg_dat.ss')
as snapshot of OKlg

SEMOGA BERMANFAAT

---