Thanks Grant, that's what I was hoping wasn't the case, but suspected was.

I think the question is how to shrink it?

Assuming that you don't need point in time for however long it took to grow to 200GB you can clear the log...

I think you are coming at this from the wrong angle. You need to define your requirements a bit more, rather than looking at your hardware and asking what...

Hi Doug,

Right click the database and choose "Tasks->Ship Transaction Logs"

This should all be already set up with your current configuration. Under Secondary databases it will...

Mostly it's about features, but it is also about upgrade paths. If you go with standard and later decide that is not enough you can upgrade to enterprise edition...

Before you try the above which does involve restarting the server and can be painful in a new environment when you aren't sure what applications are connecting and what credentials...

It depends on how you define 'limited experience'. I have 5 years administration experience and there were questions I wouldn't have got without studying quite hard. But then...

From memory it was about a 50\50 split, potentially a little more on the development than the administration. I had the opposite issue to you, coming from a DBA...

Whoops - this shouldn't be in the 2005 section - it's SQL 2008 R2 Standard Edition. I've reposted in the 2008 general section. Can a mod please delete...

Hi,

This is just a guess based on what you've said, but how long is your optimization taking to complete? As you are using enterprise edition I'm assuming...

Hi Josh - rather than give the answer I'll show you how to get the answer - which is much more valuable.

Do your restore step and then on the new...

Hi All,

I have reposted this question here:

http://www.sqlservercentral.com/Forums/Topic1415539-2799-1.aspx

Linked servers do not create logins\users, they map between them. What you are trying to do seems to be map a SQL Server login on the remote server to...

Hi Mr Holio,

I know your question is a year old on a thread that's 2 years old, but it still came up in my search so I thought...

Thanks Chris, same issue, same resolution. Agent wouldn't start and threw this error whether I tried to change startup type via configuration manager or though management studio(failure not...