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?
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:
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:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.