December 8, 2011 at 5:31 pm
I have a sql server 08 R2 express edition and as per the edition, it supports upto 10GB of database only. I have a backup database of size 20 GB and I am wondering can I split that backup file and restore onto two databases. I am much new the Administration and please help me with your suggestion or provide me if any code applicable. Thank you
December 8, 2011 at 6:12 pm
The simple answer, no.
December 9, 2011 at 12:03 am
Backup / Restore would not be a right option for you. Try to split your data in source server or in ETL. For Example export selective tables in multiple DBs.
December 9, 2011 at 6:11 am
haivenki3 (12/9/2011)
@DEV: If we split the data, then we might encounter constraint issues, right?
Not necessarily. If you can logically group few tables which are not connected with others with foreign keys, it will work. Its work around only, you should re-consider choosing higher editions.
December 9, 2011 at 10:56 am
Will try..Thank you
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply