Post reply

Moving Datafiles

  • March 27, 2019 at 11:35 am

    #2033872

    I have a number of databases with spaces in the name of the database. No matter what I try to use so I can move the datafiles I get a syntax error. What do I need to use to move database datafiles with spaces in the database name?

  • March 27, 2019 at 11:57 am

    #2033991

    keanyukas - Wednesday, March 27, 2019 11:35 AM

    I have a number of databases with spaces in the name of the database. No matter what I try to use so I can move the datafiles I get a syntax error. What do I need to use to move database datafiles with spaces in the database name?

    It's hard to say being that we don't know what you tried. Usually you need the database name in brackets - did you try that? Something like:
    ALTER DATABASE [Your Database Name With Spaces]
    MODIFY FILE ( NAME = LogicalName , FILENAME = 'NewPath' )

    Sue

  • March 27, 2019 at 12:22 pm

    #2033997

    alter database ENR Access DB
    set offline
    go

    Msg 102, Level 15, State 1, Line 6
    Incorrect syntax near 'Access'.

  • March 27, 2019 at 12:28 pm

    #2034001

    keanyukas - Wednesday, March 27, 2019 12:22 PM

    alter database ENR Access DB
    set offline
    go

    Msg 102, Level 15, State 1, Line 6
    Incorrect syntax near 'Access'.

    Try brackets around the database name [ENR Access DB]

    Sue

  • March 27, 2019 at 12:30 pm

    #2034003

    As Sue mentioned, you need to use [   ]. In your case that would be  " Alter database [ENR Access DB] "

  • March 27, 2019 at 12:32 pm

    #2034004

    That worked thanks did everything but that

  • March 28, 2019 at 5:29 am

    #2034074

    When I try the alter command I get an error but all other commands work
    alter database [ENR Access DB]
    set offline
    go

    move files

    alter database [ENR Access DB]
    modify file (name=ENR Access DB_log,filename="F:\Database Logs\ENR Access DB_log.LDF")
    go

    alter database [ENR Access DB]
    set online
    go

  • March 28, 2019 at 6:14 am

    #2034079

    Can you post the error you are getting?

    Thanks

  • March 28, 2019 at 6:21 am

    #2034080

    Msg 153, Level 15, State 1, Line 8
    Invalid usage of the option Access in the CREATE/ALTER DATABASE statement.

  • March 28, 2019 at 6:35 am

    #2034081

    So you say that all other commands work, which alter statements work and which don't?

    Thanks

  • March 28, 2019 at 6:48 am

    #2034085

    I get the error with the modify file statement

  • March 28, 2019 at 7:00 am

    #2034088

    Try this:
    alter database [ENR Access DB]
    modify file (name='ENR Access DB_log',filename='F:\Database Logs\ENR Access DB_log.LDF')
    go

    Thanks

  • March 28, 2019 at 7:05 am

    #2034089

    That worked thanks

Viewing 13 posts - 1 through 12 (of 12 total)

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