SQL Server 7.0 Upgrade Failure

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

We have a SQL Server 6.5 database that is apx. 20 Gigs in size. When we try to do a 2 computer upgrade to 7.0, we get the following errors. How big does the temp DB have to be and is there a way to just dump the data without having to use the temp db? Is there a better way to upgrade a LARGE sql server 6.5 database to 7.0?

1999-04-02 17:48:04.42 kernel D:\MSSQL\DATA\tempdbData.ndf: Operating system error 112(There is not enough space on the disk.) encountered. 1999-04-02 17:48:04.42 spid7 Error: 1105, Severity: 17, State: 2 1999-04-02 17:48:04.42 spid7 Could not allocate space for object '(SYSTEM table id: -1030594625)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.. 1999-04-02 17:48:06.17 spid7 Convert6x: execsql maj=11 min=5 error=1105 state=2 severity=17 1999-04-03 16:21:08.64 spid7 Convert6x: execsql maj=73 min=99 error=7399 state=1 severity=16 1999-04-03 17:09:57.25 kernel C:\MSSQL7\DATA\TEMPDB.MDF: Operating system error 112(There is not enough space on the disk.) encountered. 1999-04-03 17:09:57.25 spid7 Error: 1105, Severity: 17, State: 2 1999-04-03 17:09:57.25 spid7 Could not allocate space for object '(SYSTEM table id: -920332231)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.. 1999-04-03 17:10:00.42 spid7 Convert6x: execsql maj=11 min=5 error=1105 state=2 severity=17

-- Anonymous, April 05, 1999

Answers

Eric,

I suggest that you make tempdb about 25% of the size of your large database, that is, about 5 GB.

Eric

-- Anonymous, April 06, 1999


Moderation questions? read the FAQ