Step 1: Log In with Remote Desktop Step 2: Run Microsoft SQL Server Management Step 3: Checking the Server Authentication Mode Step 4: Restart the SQL Service Step 5: Checking SQL User Permissions Step 6: Mapping the User to the Database

I suggest using regular SQL jobs, using the Ola Hallengren solutions for your backups. Ola hallengren has a full (free) maintenance solution that you can download and deploy on your server. It's used by a lot of Database Administrators and has been around for years. All you have to do is deploy the scripts and add some schedules to your full/diff and log backups job. You can also fine-tune everything to fit your needs. There are code examples and options on the Ola site. A big benefit you get from this is that you can simply script out everything, and deploy it on any server you want, without much hassle. Along with this, it also includes jobs like IndexMaintenance and IntegrityChecks, which are needed on any SQL Instance. So it's a good all-in-one solution.

How to Copy Database wizard in SQL Server

The Copy Database Wizard moves or copies databases and certain server objects easily from one instance of SQL Server to another instance, with no server downtime. By using this wizard, you can do the following:

• Pick a source and destination server.
  
• Select database(s) to move or copy.
  
• Specify the file location for the database(s).
  
• Copy logins to the destination server.
  
• Copy additional supporting objects, jobs, user-defined stored procedures, and error messages.
  
• Schedule when to move or copy the database(s).
  

Hope this will help you to copy databases in SQL Server !!