Were you able to do any activity on the sqlserver? what do you see in services?

Is it single node cluster or multiple ? ,If it is multiple then you may...

bcp out the syslogins table in master database

Has anybody else ever encountered the excessive time it takes on large data files to empty them or is this normal?

For moving around 600 GB file it took around 8...

I have little experience in doing this but I did this on 10 TB OLAP database. we had around 20 data files which are residing on 4 filegroups and I...

Lets see..

A - SQL 2005 on Windows 2008 - virtual

B - SQL 2005 on Windows 2008 - virtual

A and B on same physical host.

C - SQL ???? on Windows 2003...

Thanks

Thanks.

Can we force sql server to truncate log at my convience (using checkpoint...) at the earliest rather than sql server doing by its own?

Cool

Thankyou Verymuch.

we have 100's of users in a database how can I give select permission for all the users in a single shot?

Thank you

Now its working.

I have droped the user and recreated

login camplained me this..

when I open my server login properties and view "User Mapping" I get the message "One or more databases are inaccessible and will not be displayed...

Excellent Shaw .. I got it.

Thankyou verymuch..

The compresstion level is lite speed default compresstion level(1) ..

The ldf file size is 9.5GB and mdf file allocated size is 4.5 GB( We can assume that data is 15.6...

Just I want to know can we take a t-log backup after Differtial backup ?

Do you mean that the log itself is corrupt, or that the backup that you took is corrupt?

I mean t-log backup NOT ldf file.

-- Suppose we took differnetial at...