This question has posted twice(by mistake) check here http://www.sqlservercentral.com/Forums/Topic1533511-391-1.aspx

But you can answer for the question there.Also how can I delete this question as it is double posted?

Can anyone help me to troubleshoot the said problem?

Also a nice explanation here for my question.

So can i change the size...

sreekanth bandarla (11/14/2013)

---

1.Make sure Service account has permissions at the Root level of the Drive.

2.Check for FAT32/NTFS - If FAT32, I think you need to specify TABLOCK option(Am not 100%...

To avoid lot of auto-growth i have set the initial size to 100 mb based on the size and content of database.

I want to shrink the database to initial size which i have set for mdf and ldf file. I have set initial size for the database after creating the database.It...

When does page lock and row lock is taken?

can you please have a look at my question here

HowardW (8/9/2013)

---

sys.dm_exec_requests is the DMV with this information. There's a blocking session ID column. If you want something pre-packaged and easy to use in the future, I'd recommend sp_whoisactive.

Read committed...

Does nested transactions only supported in Transaction Statements(Transact-SQL ) ? In coding i am using 'sqlconnection' object. But inner transaction gets comited even though outer transaction fails

We tried to implement it.But if inner transaction gets commit first.I want inner transaction to roll backup if outer transaction...

If VLF count is more (about more than 100) then shrinking is necessary?

How to know the size to be set for the log file? Whether any method is there by which i can set ideal size for my ldf file.

I want to know how exactly log backup is different from differential backup? Because the differential backup contains differences from last full backup where as log backup is also used...