December 20, 201015 yr I'm working on a data migration using a SQL Server Express 2005 install, and a MIGRATE database on an external drive. From my testing I've been working with at MOST 2GB of data. For this, tempdb, the working database which resides on my fastest drive is doing all the legwork and then handing off the finished product to my external drive for storage once it does it's thing. My question is, when I'm working with 100GB of data for a proper migration, will tempdb write off the data to the larger drive throughout the process. The drive it's working with is a 64GB SSD, and I fear it will fill up throughout the process. As it is, I have not tried to relocate the tempdb. I thought by default it would be smart enough to write off the data to my proper database on the external drive if it got too big during the migration.Can anyone tell me if this is true? Or should I move my tempdb to the external drive as well? Pardon my ignorance, I am an Oracle DB guy, but it's been a few years since I've worked with SLQ Server 05.Thanks.
Create an account or sign in to comment