In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

If you can, you can use the standard 'BACKUP DATABASE' sql, though you'll have to write a script and schedule it manually. You can also use the sqlbackup command or whatever it is.<BR><BR>But ...

These steps do not represent an exhaustive list, but they are a good start to forming a sound database backup and recovery strategy.

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...