Dec 1, 2003 #1 jray67 MIS Jul 25, 2003 2 US In Progress we do a dump&load of the database to gain disk space and performance, is there an equivalent in SQL Server 2000? Thanks, Jimmy
In Progress we do a dump&load of the database to gain disk space and performance, is there an equivalent in SQL Server 2000? Thanks, Jimmy
Dec 2, 2003 #2 Nowell IS-IT--Management Jan 2, 2003 245 GB Hi, Backup and restore is the same, you can also use DBCC SHRINKDATABASE and DBCC SHRINKFILE to gain disk space. Nowell Upvote 0 Downvote
Hi, Backup and restore is the same, you can also use DBCC SHRINKDATABASE and DBCC SHRINKFILE to gain disk space. Nowell
Dec 2, 2003 Thread starter #3 jray67 MIS Jul 25, 2003 2 US Thanks! I appreciate the info. Jimmy Upvote 0 Downvote