I agree with Wilfred van Dijk. Wilfred van Dijk has explined very clearly.

I would say, take a FULL db Backup and try for TLOG backup and then Shrink you log file.

I completly agree with you Mr or Mrs. 500

Good Script, But you can schedule from MP as well.

There is only one way to start the SQL services. That is also manually. Go to Controll pannel and servies. Go to Property of SQL services and change to automatically...

It's depend on the Configuration for the DR Solution. Why we need DR? what is the baseline for that? How you can configure for that?

DR means if primary fail then...

It is the part of Best practice that you should have to remove the Builtin admin from the SQL server.

Before deleting Builtin admin from the server, you need to make...

SQL and os will take the Memory as they needed. If you want to strict for SQL and OS, you may need to enable the AWE on SQL server side.

You can say it's a Microsoft bug. Sometimes we have seen Some MP's or Job will created and it wont run properly. In that case make sure you have to...

I would recommend to with new Installation of new instance and move the things from old to new sever then make changes what you wnat to do?

For SQL 2005 you need to follow this steps.

• You can transfer logins and passwords from SQL Server 7.0 and 2000 to SQL Server 2005.

• You assign logins to...

Fragmentation exists when indexes have pages in which the logical ordering, based on the key value, does not match the physical ordering inside the data file. All leaf pages of...

Simon this would be for DB level. Which I mentione that is for Server level.

Here you for for script....

---------------------------------First Scriopt-------------------------

--SP_Revlogin

USE [master]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE PROCEDURE [dbo].[sp_help_revlogin] @login_name sysname =...

Good tosscrosby,

Appreciate for explanation, I forgot to add those point in my previous reply.

Tip of the Day...

"Pages will not migrate between files during an index reorganization".

I agree with you, but as per the application criticality and Organization concepts. Some of the things you only can suggest, that is not in your hand, but something you...