Transfer logins and passwords between instances of SQL Server
backup databases and restored it into new instances or database server quite easy, but the challenge is how to move the logins and password?
How to create a full database backup in SQL Server 2008 R2 by using SQL Server Management Studio and Transact-SQL, As a database increases in size full database backups take more time to finish and require more storage space. Therefore, for a large database, you might want to supplement a full database backup with a series of differential database backups.