I am using sql 2000 and have created some databses on it. I want to know ho to take full backup of the database not just the data but the whole database with fields on my server d: drive. The backup option asks for a backup to file option but it creates a normal file only with data. Any site recommendation which has a step by step method of backing up and restoring the sql db.<BR><BR><BR>Thnxx<BR>brij <BR>