sqlÓï¾ä

1.´´½¨Ò»¸öÊý¾Ý¿âʱ
ÓдíÂð£¿Ëü×ÜÊÇÌáʾdbd.ldfÒѾ­´æÔÚ µ«ÊÇÔõô¸ÄÃû¶¼»¹ÊÇÒ»ÑùÌáʾ´æÔÚ
create database testdb
on primary
(name=db1,filename='e:\java\zy\dba.mdf',size=1,maxsize=5,filegrowth=1),
(name=db2,filename='e:\java\zy\dbb.ndf',size=2,maxsize=10,filegrowth=2),
(name=db3,filename='e:\java\zy\dbc.ndf',size=2,maxsize=10,filegrowth=2)
LOG ON
(name=db4,filename='f:\dbd.ldf',size=1,maxsize=10,filegcrowth=1),
(name=db5,filename='f:\dbd.ldf',size=1,maxsize=10,filegrowth=1)
2.create database tx1
(name=abc,filename='e:\SQL server\program\data.mdf',size=1MB,maxsize=100MB,filegrowth=1MB)
log on
(name=cde,filename='e:\SQL server\program\data1.ndf')
ΪʲôÓÐÌáʾ˵name¸½½üÓдí ÓÐÂ𣿣¿
ÐÂÊÖÇë½ÌÊÖ    лл

---

(name=db4,filename='f:\dbd.ldf',size=1,maxsize=10,filegcrowth=1),
(name=db5,filename='f:\dbd.ldf',size=1,maxsize=10,filegrowth=1)


Ó¦¸ÃÊÇÕâÀï

---

create database tx1
on
(name=abc,filename='e:\SQL server\program\data.mdf',size=1MB,maxsize=100MB,filegrowth=1MB)
log on
(name=cde,filename='e:\SQL server\program\data1.ndf')

---

Ò»ÑùµÄÂï

---

SQL code:
--¶Ô£ºÖظ´¶¨ÒåÁË£¡
--ÎļþÃû²»ÄÜÖظ´¶¨Ò壡