1.If you need to check at the individual file level-what the used space, free space and what is the auto growth then use the below query:

Use <database Name>

Go

SELECTfilegroup_name(groupid),Name, Filename,

CONVERT(Decimal(15,2),ROUND(a.Size/128.000,2)) [Currently...

Are you facing the issue like completely the the query window goes off or shows the status like not connected in the query window after executing the queries because there...

Don't know whether the below useful or not, But if you need you can check from your end.

1.Are you punching the right server name\Instance Name for eg: you can...

Iam thinking that the DB mirroring is at the database level is 1:1 and for log-shipping is 1:N.

This especially some what tricky question & you cannot estimate how you can control the Logfile from the grow during rebuild index, because you know that rebuilding an index...

Is it safe to repeat that procedure until I recover all the available space?

Sorry for the late reply,The which I said is for one of the option Because I have...

Hi,

Can you try increase few MB's like 10 or 20MB for the File ID 1 then try shrinking.

Best Regards,

Rama Udaya.K

ramaudaya.blogspot.com

Hi ,

Can you please check below link

http://msdn.microsoft.com/en-us/library/ms173730%28v=SQL.90%29.aspx

Seems your rollack completed after you killed.

it says(SQL 2005):

If the rollback of the session ID or UOW has finished when the KILL...

Tuf file will not store in the database,exists at the file system level where you have specified by Manually, where we are defining the Transaction undo file to make the...

Hi,

Yes you can perform the activities(but it is your own risk ->you need to ensure many factors from your side

why you are planning for cold backup,downtime, etc...).

you can schedule task...

Service Broker ->it is an new feature in SQL server 2005(in sql server 2000 it is not there),Developers can take advantage of this new feature for Ex-

When performing DML activity...

When did this happened?Any activity was done recently where the MSDB hosts(like MSDB restoration,files moved)?

Also check below status-

1)Check the SQL server agent status & also the DB engine.

2)check the SSAS...

Hi Ravi,

It is bit difficult (how ever if you have set up some triggers when ever the index is used),how ever we can use DMV to get some useful information...

Hi,

If you want to know what exactly the DLL does in SQL server you can go through the below Link

http://dll.paretologic.com/detail.php/xpstar

2)To know about how SP_readerrorlog will works.

http://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/

Thanks,

Rama...

Hi ,

Why Cant you use the best option Backup and restore method using T-SQL instead of detach/attach method.

1)You can perform DBCC CHECKDB on the source database or identity when...