Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2000

Status
Not open for further replies.
jray67

jray67

MIS
Joined
Jul 25, 2003
Messages
2
Location
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
 
Sort by date Sort by votes
Hi,

Backup and restore is the same, you can also use DBCC SHRINKDATABASE and DBCC SHRINKFILE to gain disk space.

Nowell
 
Upvote 0 Downvote
Thanks! I appreciate the info.


Jimmy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question Question
SQL Server in Windows
Replies
1
Views
1K
pjw001
pjw001
CodeWell
  • Locked
  • Question Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
887
CodeWell
CodeWell
bethabernathy
  • Locked
  • Question Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
747
dhookom
dhookom
Ikatiemarie
  • Locked
  • Question Question
SQL Server 2008 SP_Send_dbmail
Replies
0
Views
1K
Ikatiemarie
Ikatiemarie
dgillz
  • Locked
  • Question Question
SQL View not available to Excel Power Query
Replies
1
Views
772
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top