Posted by shiju on 02/17/07 07:01

A full DB backup of one of my database takes around 3 GB. Half of this
is index. All the indexes are in different filegroup. I am wondering
if I can only backup the data. For Index I can always run the script
to regenerate it.

By doing this I can reduce the size of the backup file.

Thanks
~Shiju

• Next in forum: Connecting Sql Server 2005 on Windows 2003 using ASP local
• Prev in forum: Re: Encrypting mdf files
• Thread view: Full bakup of Data

[Reply to this message]