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 ATTACHWhat'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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment