Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Unanswered: attaching database on create

    Hi,

    My current server going nuts it restaring every one hour, I have 200+GB (80+ files) database size. The network guyes don't have backup. This is what I am trying to do. I have detach my database. I have copied all the file to new server. Now i am trying to attach using create, I can't just use attach because 16+ files. When I run following on my server it gives me an error.

    Any help will be highly appreciated.

    please email me the answer if you have.

    Thanks.

    Samir

    CREATE DATABASE KEYFILE
    ON PRIMARY (NAME= 'KEYFILE001' FILENAME='F:\KEYFILEDB\KEYFILE001.MDF')
    ON SECONDARY (NAME='KEYFILE002' FILENAME='F:\KEYFILEDB\KEYFILE002.NDF')
    ON SECONDARY (NAME='KEYFILE003' FILENAME='F:\KEYFILEDB\KEYFILE003.NDF')
    ON SECONDARY (NAME='KEYFILE004' FILENAME='F:\KEYFILEDB\KEYFILE004.NDF')
    ON SECONDARY (NAME='KEYFILE005' FILENAME='F:\KEYFILEDB\KEYFILE005.NDF')
    ON SECONDARY (NAME='KEYFILE006' FILENAME='F:\KEYFILEDB\KEYFILE006.NDF')
    ON SECONDARY (NAME='KEYFILE007' FILENAME='F:\KEYFILEDB\KEYFILE007.NDF')
    ON SECONDARY (NAME='KEYFILE008' FILENAME='F:\KEYFILEDB\KEYFILE008.NDF')
    LOG ON SECONDARY (NAME= 'KEYFILE_LOG' FILENAME='F:\KEYFILEDB\KEYFILE_LOG.LDF')

    FOR ATTACH

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: attaching database on create

    What's the error message that you are getting?

    A superfluous comment would be that 80+ files seems a bit much. Is there not some way for you to decrease the number of files (moving objects, etc)?

    Regards,

    hmscott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •