You are right. Just found following 'Setting Up Log Shipping'.

http://msdn.microsoft.com/en-us/library/aa496029(v=SQL.80).aspx

But when I go to my bookmarked page 'Log Shipping Overview', I don't see SS2K and that made me confuse.

http://msdn.microsoft.com/en-us/library/ms187103.aspx

Besides...

Elliott Whitlow (12/1/2011)

---

Yep, the red box in the upper right corner saying "a community service from redgate" is kind of a give-away.. However, I have yet to see anybody...

Frodo

@mikejean17: I can ignore SPAM but not copying to Lynn. 😛

Divine Flame (12/2/2011)

---

ananda.murugesan (12/1/2011)

---

Hi, i am going for high availability option not for report purpose,

Mirroring option- It is not possible for configure for different version because primary database is...

jeyis (12/1/2011)

---

Hi ,

I have a requirement to show an output with new line breaks in one of the output column. This is not possible in sql server 2008 Grid output....

Create your silent installation script & run it on multiple servers.

Example

Setup.exe /q /ACTION=CompleteImage /INSTANCENAME=MYNEWINST /INSTANCEID=<MYINST> /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS

How to: Install SQL Server 2008 R2 from the...

David Moutray (12/1/2011)

---

Dev (12/1/2011)

---

By using Sync Framework, developers can build sync ecosystems that integrate any application with any data from any store that uses any protocol over any...

azhar.iqbal499 (12/1/2011)

---

Thanks.

I just want to save my database from any user at live, In case if He would be able to reach the database then He must not be able...

In addition to what Sujit said, I am giving you 2 articles which I recommend to everyone who is starting on SQL Server Clustering.

Getting Started with SQL Server 2008 R2...

ananda.murugesan (12/1/2011)

---

Ok..All published tables in transactional replication must contain a declared primary key.

In...

Following article covers all what you need to know about tempdb. It's for SS2K5 but pretty much fine with SS2K8 as well.

Working with tempdb in SQL Server 2005

http://technet.microsoft.com/en-us/library/cc966545.aspx

All published tables in transactional replication must contain a declared primary key.

Considerations for Transactional Replication

http://msdn.microsoft.com/en-us/library/ms151254(v=SQL.100).aspx

Wishes!!!

+

Signature

= Hilarious :hehe:

If your core objective is to save disk space I would suggest you to cleanup something else rather log files. If acceptable add...