Greg is absolutely correct in his suggestion.

I would like to add that you can configure the SQl Server Agent to sent you a notofication (through net send or mail)...

Hi,

Check the collation. You can use the following command:

select serverproperty ('collation')

This command will give you the collation of your server.

Now the database that you are getting on your server, you...

Hi,

sa is by default system administrator. I don't understand your problem. See sa is login while dbo is db user. Please be presice on the problem.

regards

Pankaj

Its always advisable to backup the system databases. It should be a part of disaster recovery plan. If something happens to your SQL Server in future, for which, you have...

Hi Harry,

You can also use the RESTORE DATABASE command to do this:

RESTORE DATABASE <put-new-database-name-here>

FROM

FILE = '<write-the-complete-physical-path-of-the-backup-file-here>'

WITH

RECOVERY,

MOVE '<logical-mdf-file-name>' TO '<physical-path-of-the-mdf-file-on-new-server>',

MOVE '<logical-ldf-file-name>' TO '<physical-path-of-the-ldf-file-on-new-server>'

After restoring the database, you will have to...