go through this link http://www.windows-tech.info/15/1d7cfc521f352be2.php

from the above link, your scenario should work and Tail backup can be of any size (may be in GB) depending on the transactions occurred and...

Could you please advice me on how to calculate Disk Queue length..

That I don't know so you need to plan and run tests before implementing it but you need to take care of it because

I...

Yes, We have windows 2003 EE R2 x64 with SP2 and SQL Server 2005 EE x64 with SP3.

Does reinstalling .net 2.0, affects the SQL Server?

How can I reinstall .net 2.0...

could you please advice me..

thanks

Thank you,

If your data, log, and tempdb and the C drive (OS drive) are on SAN, then you will enable the Write cache or NOT?

I went through the link http://support.microsoft.com/kb/281672...

I think we do not need to install the Visual studio 2005 on production server and it's only required on Developer machines right?

and also Books online and workstation components are...

thanks,

I'm not sure what you are asking. Do you want to find the time you took the tail log backup or do you want to add a timestamp to the...

thanks,

I have executed the below script:

select name, log_reuse_wait_desc from sys.databases

where name = 'MyDB_PROD'

Results:

name log_reuse_wait_desc

MyDB_PROD ...

thank you,

we have space issue and thats why we deleted unwanted data from the database and free space is 17 GB. I want to keep free space as 5GB and...

thanks,

Its looks like we using FORM based authentication. I have noticed this from the web.config file from(C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer)

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<configSections>

<section...

thanks,

Then where did you get the idea that AD and SSRS are related because SQL Server in any Windows network is to be configured a member server. And Windows authentication...

On sunday, first rebuild indexes maintenance plan job runs (for all databases,...

Schedule more log backups during the reindex phase, this could be done by putting executions of the log backup job in the script to reindex and/or setting SQLagent performance alerts...

could you plz advice