Hi,

Can anyone please tell me if "cold" backup is possible in SQL Server 2000 ? I wish to know if I can take a backup of the database when the database is down, or offline. I know this is possible in Oracle but would like to know if this concept exists in SQL Server.

Thanks for your help.

Vidya

Check this out :: http://www.microsoft.com/licensing/p...t/drtools.mspx -- Is this what you are looking for?

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

No. I would just like to know if we can take a backup of the database while it is offline. If yes, how can I do it ?

Thanks,
Vidya

To my knowledge it can't be done in SQL Server 2000. Anyway just try copying the mdf/ldf files and attach it in the destination.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

stop all services of sql server database by control panel.
it meance it is in offline.
use enterpriese manager - tool - backup option

it will be offline backup.

I tried stopping the SQL Server services from control panel and taking a backup. But it is not letting me take a backup. Says "the connection to SQL Server has been broken". any other ideas of achieving this ?

Thansk again..
Vidya

if the service is stopped then the SQL server is stopped.

Put the database in single user mode, thus the service is still running, your the only one connected, then you should be able to backup the database. If thats what your asking.