| |

VerySource

 Forgot password?
 Register
Search
View: 576|Reply: 1

Please educate the question

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-2-6 23:30:01
| Show all posts |Read mode
create database data1
on
primary
(name = data_m1,
filename = 'e:\sql\data1\data_m1.mdf',
size = 1,
maxsize = 10,
filegrowth = 1),
(name = data_n1,
filename = 'e:\sql\data1\data_n1.ndf',
size = 1,
maxsize = 10,
filegrowth = 10%)
filegroup group1
(name = data_n2,
filename = 'e:\sql\data1\data_n2.ndf',
size = 1,
maxsize = 10,
filegrowth = 1),
log on
(name = data_l1,
filename = 'e:\sql\data1\data_l1.ldf',
size = 1,
maxsize = 10,
filegrowth = 1)
With this statement, appears
Server: Message 170, Level 15, State 1, Line 14
Line 14: Syntax error near 'filegroup'.
Don't know where the problem is, help me
Reply

Use magic Report

0

Threads

211

Posts

108.00

Credits

Newbie

Rank: 1

Credits
108.00

 China

Post time: 2020-3-27 10:00:01
| Show all posts
--try

create database data1
on primary
(name = data_m1,
filename = 'e:\sql\data1\data_m1.mdf',
size = 1,
maxsize = 10,
filegrowth = 1),
(name = data_n1,
filename = 'e:\sql\data1\data_n1.ndf',
size = 1,
maxsize = 10,
filegrowth = 10%),
filegroup group1
(name = data_n2,
filename = 'e:\sql\data1\data_n2.ndf',
size = 1,
maxsize = 10,
filegrowth = 1)

log on
(name = data_l1,
filename = 'e:\sql\data1\data_l1.ldf',
size = 1,
maxsize = 10,
filegrowth = 1)
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list