Hey Dude,

As you are using Windows workgroup you would not have fully qualified server name.

So when it ask start mirroing then on that pop up press "DO NOT START MIRRORING"...

Hi,

Run ur LS_BACKUP up job for two times then shrink log file

if it couldn't then Run LS_BACKUP job one more time and shrink

Regards

Zishan

Hi Dude

1st check this

select name,log_reuse_wait_desc from sys.databases

it will show reason why ur log is not getting reused

if it shows 'Log Backup' and then take log backup and shrink

if it is...

First you check fragmentation level on your database with help of following query

use [your database name]

SELECT

OBJECT_NAME(i.object_id) AS TableName ,

phystat.index_type_desc,

i.name AS TableIndexName,

phystat.avg_fragmentation_in_percent

FROM

sys.dm_db_index_physical_stats(DB_ID(your database Id), NULL, NULL, NULL, 'LIMITED') phystat

inner...