Good article .Helps us a lot.

Thanks,

Nagesh.

Hi,

Can you please validate the backup set with the below command

RESTORE VERIFYONLY FROM DISK='[Mention the path of backupfile]'

Thanks,

Nagesh

1) Open Microsoft SQL server Management Studio

2) Expand security and right click on Logins then select new login.

3) Under the General page give a login name as ‘ABC’...

Hi,

1) Yes, you can install in different logical drives so that here will be no override.

2) You can install 2000 and 2005 with different instance names.

Thanks,

Nagesh

Hi,

Select count (*) from sys.databases

Thanks,

Nagesh

Thanks Erik

So, it's better to go with per poceesor mode .

what does the statement "SQL Server License coverd by SA"

How can I find whehter the existing License coverd...

Thanks Erik

So, it's better to go with per poceesor mode .

what does the statement "SQL Server License coverd by SA"

How can I find whehter the existing License coverd...