November 21, 2008 at 6:36 am
Is it true that one database can have the maximum size of 8GB in sql server 2005?
which edition of SQL server are you using?
check this out
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
November 21, 2008 at 8:56 am
I am using Sql Server 2005. So, before I start importing, change the recovery model to BULK and once I am done importing, change it back to FULL. I will do that. So, then once I am done deleting the data, i should truncate the log file, right? Thanks for your help P_DBA. Awesome!!
November 21, 2008 at 8:58 am
which edition of SQL server are you using?
I am using Enterprise edition.
November 21, 2008 at 9:34 am
Yes, thats right switch the recovery model to full and with enterprise the size of database is unlimited..Yes you should truncate the log once u have done deleting the data....
Or
You can completely delete the database and start a new database with new data files and log files......and import the huge data into the new one making sure that your recovery model is in bulk logged......
cheers!
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply