Backup table in a database

[Armani]

Hello friends! i have migrated form sql 65 to sql 2000, in sql 65 the full backup of my database have 350 - 400 mb, but in sql 2000 have 2 gb of backup. can i fix this?
another question, can i backup a table of my db?

thanks!

 

[tlbroadbent]

What is the size of the database? The backup size should be similar. Were any changes made to datatypes, collations, indexes, etc that could account fo the size difference?

The ability to backup up a table was removed in SQL 7. SQL 2000 cannot backup or restore individual tables. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[MuteXaholic]

For backing up table: you can move table to different file than backup the file.

 

[Armani]

the size of my db is about 400 mb, and the transaction log 400 mb too... the total size is 800? why the bkp is 2 gb?

 

[tlbroadbent]

Are you overwriting the backup or appending to the backup? Check your maintenance plan or backup script to make sure the file is initialized for each backup.

We create a new file name for each backup and delete older backup files. Each file name contains the date and time. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.