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
 General SQL Server Forums
 New to SQL Server Administration
 logshipping

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-11-09 : 10:49:57
Our prod server has sql server standard edition 9.00.1399

Can we do logshipping from prod to dr server(same sql version as prod)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-09 : 11:00:43
Why don't you have service pack 3 installed plus the critical SQL hotfix (build 4262)? There are thousands of bugs in build 1399.

Yes log shipping is supported in standard edition, which you can easily find by googling it and coming up this article: http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx


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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-11-09 : 15:19:26
Do we need to purchase service packs or those are free since we have server license?

And also can we setup logshipping for multiple databases at a time i mean in single logshipping set up?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-09 : 18:37:02
Service packs, hotfixes, cumulative update packages, QFEs, GDRs, etc... are all free.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-11-11 : 14:24:45
How do we setup a shared folder? SQL server is running on local system account on servers
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-11 : 15:44:25
In order to use log shipping, you'll need to use a domain account and not the local system account.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -