Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 server

Author  Topic 

biranchi.mohapatra
Starting Member

6 Posts

Posted - 2010-09-24 : 14:04:17
Hi All,

If server is down then how we will take backup.


Thanks
Biranchi

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-24 : 14:06:09
You won't and can't. Consider using database mirroring, clustering, or log shipping.

How do I put my shoes on if I don't have any?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

biranchi.mohapatra
Starting Member

6 Posts

Posted - 2010-09-24 : 14:09:23
Thaks Tara

Best Regards,
Biranchi
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-24 : 14:27:12
You're welcome, glad to help.

So what's with all of your questions? Are you preparing for a certification test?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

biranchi.mohapatra
Starting Member

6 Posts

Posted - 2010-09-24 : 22:56:06
Yes Tara

Thanks
Biranchi
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-09-25 : 03:34:29
Ermmm ... can't you do a tail log backup with server down? (well, service started in special mode - I forget the command exactly ...)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-25 : 13:07:07
I assumed the OP meant that the actual box was down and not just the service.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-09-27 : 04:01:45
Hehehe ... good point. Pretty hard to do anything if the server itself is dead. Book-end perhaps?
Go to Top of Page
   

- Advertisement -