Yeah, I did read Brad's book and it's a fantastic book.

Do you have the SQL login -- 'sql2005login' at both the Instances?

Have you worked on SQL Server? on Log Shipping in SQL Server?

The reason to question is, if you are starting to learn SQL Server. It's better to start going through...

This is SQL 7, 2000 Forum, and Database Mirroring is available in SQL 2005 and above.

Please respond to this question in the thread below.

http://www.sqlservercentral.com/Forums/Topic828190-5-1.aspx

Adding to what Lowell has said, if at all you need to test the application and need a copy of these databases, your application will need all of the related...

Yes I do agree, but my by the end of the evaluation period, the one who is pursuing, would also realize if its going to be their field or switching...

Yes Lynn, Dev edition is also a choice, but wanted to advice eval edtn, so that he can skip that $50 to start the prep going.

No you don't need SP1 and SP2. Service Packs are cumulative, so the...

alan.nichol (12/3/2009)

---

No...we reclaimed around helf of the 750gb drive when I issued the ALTER DATABASE command, however, were a bit concerned that this excessive growth with come back again and...

As Gail Shaw has pointed out, by limiting your log file size you are asking for similar problems more often.

It is a good point, to revisit that code that caused...

Yes Colin, I agree with you. There are multiple alternatives to achieve this, but with a database backup, the entire database in the production is moved, which may not be...

100 MB for Master Database is more than enough. Keep it that way.

So, you recovered 6.8 GB right ! 🙂

By seeing your initial post, I thought you understand only emoticons, so I replied only thru emoticons.... Got it?

Any way, I...

Welcome ! 🙂

Yep !