quote:

---

I normally do take backup locally and copy files to NAS.What is the best practices?

---

USE [Your_Database_Name]
GO

BACKUP DATABASE [Your_Database_Name]
TO DISK = [PATH/LOCATION WHERE TO BACKUP YOUR DATABASE "Your_Database_Name.BAK"]
MIRROR TO DISK = [PATH WHERE YOU WANT TO LOCATE THE COPY OF YOUR DATABASE "Your_Database_Name.BAK"]
WITH FORMAT
GO

BACKUP LOG [Your_Database_Name]
TO DISK = [PATH/LOCATION WHERE TO BACKUP YOUR DATABASE "Your_Database_Name_log.BAK"]
GO

BACKUP DATABASE [Your_Database_Name]
TO DISK = [PATH/LOCATION WHERE TO BACKUP YOUR DATABASE "Your_Database_Name1.BAK"]
   DISK = [PATH/LOCATION WHERE TO BACKUP YOUR DATABASE "Your_Database_Name2.BAK"]
   DISK = [PATH/LOCATION WHERE TO BACKUP YOUR DATABASE "Your_Database_Name3.BAK"]
GO

BACKUP LOG [Your_Database_Name]
TO DISK = [PATH/LOCATION WHERE TO BACKUP YOUR DATABASE "Your_Database_Name_log.BAK"]
GO