That probably will not work. It all depends how your applications are connecting to the database.

Marco V (12/16/2011)

---

Hmm cool, i dunno been awhile ago i played arround with it. Correct me if iam wrong but i believed it was SQL 2008 R2 only.

and you could...

JohnnyDBA (12/14/2011)

---

I did look through that article last night actually. I didn't see anything that I wasn't doing correctly based on the instructions.

I'd just like to point out one...

You could use DNS forwarding, check this[/url].

ananda.murugesan (12/16/2011)

---

Hi Dev,

It is right for upgrade sql server 2000 to SQL server 2008.

I am not getting more downtime...

What about Access? 😀

How are you connecting to SSMS? I have worked with the same configuration and I have never had problems. My guess would be that you are not connecting to the...

Here are some links you can check:

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

http://searchsqlserver.techtarget.com/tip/Optimize-disk-configuration-in-SQL-Server

http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-2-after-the-install/

http://www.sqlskills.com/BLOGS/KIMBERLY/category/Transaction-Log.aspx

Good luck!

Are you 100% sure you click on "Transaction Log Shipping" after clicking on properties? Make sure it is selected "Blue".

Could you also please provide some information on the maintenance task you are executing on the Server? Thanks in advance!

mbender (11/8/2011)

---

When i ran

SELECT

db.[name] AS [Database...

You can try creating a group depending on the domain. 😉

You may want to take a look at this[/url]. Good luck. 😉

How much space of the log file was in use? Did you shrink the log file?

You are welcome. Please let us know how it goes!:-)