sql server programming: Hello,

Yes, If you have a proper backup strategy you should be able to recover all
datbases.

For setting up a good backup stretegey take a look into the topics:-

1. Recovery Models
2. FULL Database Backups, Differential and Transaction log backups

Apart from the backup stretegies take a look into:-

1. Log Shipping


Thanks
Hari


[quoted text, click to view]

Jason Huang (JasonHuang8888@hotmail.com) writes:
[quoted text, click to view]

First you need to decide: will it be sufficient to restore from a full
backup in case of disaster? In such case, taking a full backup of
the databases once a day (or what you feel is appropriate) is enough.
Make sure that the databases are in simple recovery mode.

If you need up-to-the-minute recovery, you need full recovery and you
must also backup the transaction log.

While sending the backups to a different machine is better than leaving
them on a server, it may or may be enough. How far from each other is
the server and your PC? What if disaster strikes and the entire building
goes up in flames? Bigger organisations keeps backups off-site. Then
again, if your business is a small one that would not survive a major
fire anyway, off-site storage may be over-ambitious.

Finally, whatever stratgy you go for, don't forget to test your
procedures, so that you know which steps to take in case of emegerncy.
This is particularly important if up-to-the point recovery is a
requirement.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at

Jason
Make sure that SQL Server "knows" your PC.

BACKUP DATABASE dbname TO DISK =
N'\\PCName\sharefolder\dbname.BAK'





[quoted text, click to view]

Hi,

I have SQL Server 2000 in my Windows Server 2003, there're 11 databases
running my company's applications.
I am thinking backing up the databases to my PC, in case a complete server
failed and the server just dead.
What do I need to backup from the SQL Server?
If I installed another SQL Server 2000 + Windows Server 2003 on a new
machine, will those BAK files in my PC usable for restoring the 11
databases?
Thanks for help.


Jason