You are correct.

Try it for yourself, create a test database and size the transactionlog to 100MB.

Then do the DBCC.

The 10 is the target size, so you would end up with a transaction log that is 10MB.

Hi,

there are a number of things to consider when going virtual with SQL Server and if this is new

territory you should consider training.

I went down this route a couple...

To failover to a log shipping secondary, just follow have a look at this article. Do not miss out on that .3 in the article talks

about a tail-log backup.

http://technet.microsoft.com/en-us/library/ms191233(v=sql.105).aspx

There...

Steve Jones - SSC Editor (8/6/2013)

---

WayneS (8/6/2013)

---

To go along with this, how about a second section of recently solved questions? Limit it to a few per forum topic - maybe...

About:

DATABASE PROS WHO NEED YOUR HELP

Here's a few of the new posts today on the forums..

I personally do not like it, takes up a huge amount of space.

Tried to...

You could try a couple of other things like:

1. Have a look at your maintenace plan, click edit on the subplan and click on view t-sql. Any problems there?

2. Delete...

If you have .bak as the in the file extension field, change it to only bak without any dots/asterisks and try again.

Check out this connectivity troubleshooter:

http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx

Don't forget to get the security settings right for the datafolder where the data/tlog files reside.

If you just do a copy, no security settings are moved. So have a look...

If you give us some more details ( version/edition/os and so on), you probably will get more help.

There are a couple of connect items regarding your error message like:

If you...

Hi,

you can't miss with Ola's solution regarding maintenance.

If you want to analyze your indexes, have a look at sp_blitzindex[/url].

It will tell you what is going on in your database, superb...

Since this is common task for DBA's I would spend some time to put together a nice solution.

The size of the database is probably the decider for the type of...

Hi,

It is not possible to restore 2008 R2 backup to 2008.

The only way is to export the data.

Have a look at this thread for some ideas.

From the first post:

" So...the next step is to create a backup of the db on server b and restore a copy on server a which will run as a...