Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Couple of questions about SQL DB		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

texanman
Junior Member

United States
410 Posts
Posted - 05 August 2009 :  22:58:33  Show Profile
Hello

1. If I want to remove the rows of an archive table, is the following SQL command sufficient: TRUNCATE TABLE Forum_A_Replies

2. Moving forum to a new host with a bigger SQL DB size, what do I need to do to transfer the DB? Just have a copy of backup db?

Thanks

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 06 August 2009 :  03:52:10  Show Profile  Visit HuwR's Homepage
1) if you want to remove all archives then yes
2) yes that should be sufficient
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 06 August 2009 :  09:07:52  Show Profile
Thank you so much Hu :-)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07