Reading a book and working with the product will help you a lot. Try to pick up a good book on SQL, Ms press Self-paced training kit will be a...

I suggest you go through the all the Hands-on exercises given in the Self paced book. Also you need to understand that you have covered all the topics related to...

I hope, I understand your requirement correctly. You need to backup all the databases in an instance (both system and user database).

You can configure the all database backup using...

Database Mirroring while operating in High Availability Mode provides Automatic Failover feature.

The corresponding question does not provide the correct option to choose from.

Following is the reference link from MSDN:...

It is preferable to set the job owner for critical jobs as sa. If the sa account is disabled and the instance is running using Windows Authentication, still the job...

Thanks Shawn, Forget to add info about the DENY command

Using Active directory group to assign permission is a preferred way.

If an user belongs to two groups, one with public access and another with additional access rights, the user will...

Hello Sourav,

Check this link for a detailed steps: http://ukganguly.spaces.live.com/blog/cns!3DBBCE0B87F1CF26!427.entry

Hope, this may help.

In both cases, truncation of log will not occur. As said by Gila, a log backup is required to remove the inactive portion of the transaction log.

If you want...

SQL server agent service account of the secondary server, should have both read access on the folder where your backup files are stored. The agent account of the primary server...

You need to achieve this through nested group membership. Create a group (Security, Domain Local) in AD, and add all...

Using Nested Group Membership in AD, you can achieve this objective.

Thanks a lot for your response and guidance. I am looking forward to get the book.

Thanks once again.:-)

Thanks a lot, Gil. That will clarify the doubt. I will post the other details after going through the logs.

You can use the UNC name (\\servername\sharename\backup.bak) to store your backup file on a network server. this way, you don't have to move your backup file from server to server.:-)