I have an SQL Server 2000 MSDE database and i run a script daily in order to
create a backup of the database.
The problem is that this file has become 50GB !!
The database must be a lot smaller.
What should i do ? Delete the large 50GB file so that the database is backed up in a new smaller file ?
If i ever want to restore the database will i need the large 50GB file or the smaller one will be ok also ?