Msg 1828, Level 16, State 5, Line 1 The logical file name "address" is already in use. Choose a different name.

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Comment removed did not fully read the title to this posting .....

which is Msg 1828, Level 16, State 5, Line 1 The logical file name "address" is already in use. Choose a different name

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 2

Just add the bit in bold...

create database dairy

on primary

(

name='address',

filename='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\address.mdf',

size=5mb

)

log on

(

name='address_log',

filename='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\address.ldf',

size=10mb

)