Are you using SQL Server 2000 or 2005?

george sibbald (2/3/2009)

---

As soon as you get the 20 .ldfs attached, drop 19 of them. Only reason you would want more than 1 log file is if you were totally...

Using GUI

--------

1. Open Enterprise manager or SSMS -->...

While attaching when you select the .mdf file If that .mdf file had 20 ldf files automatically it...

Thanks for the reply, I will try and let you know.

Could you please explain me how no_truncate will increase the fragmentaion level.

You can do it in different ways

1. write the query to insert the data using linked server and schedule this queriy using sql server agent.

2. SSIS package and schedule...

WOW it is good to hear from you.

Nice Thread.

Hi All,

Thanks for your reply, While rebuilding the index log file will be used or data file will be used.

I understand that it will use only log file not...

Singh,

What is the reason you are not running backup log with truncate_only.

If you run the backup log with truncate_only, I am sure your log file will be shrinked.

You are welcome

It will complete in 2 to 3 min, it is not taking much time.

I did changes on server itself not from client.

yes that is right you performed a striped backup, you can't restore until you find another file.

The below will drop and recreate the index.

DBCC DBREINDEX (TempLan_Details , '', 70)

There is problem with the table 'postnet.TempLan_Details'

Run DBCC CHECKTABLE on TempLan_Details' with REPAIR_REBUILD or REPAIR_FAST

After this still if you are facing the problem,

1. Drop and recreate the...