Cacher is the code snippet organizer for pro developers

-------------------sqlserver
--detach db
EXEC master.dbo.sp_detach_db @dbname = N'nopCommerce'
--restore db
RESTORE DATABASE [nopCommerce] FROM  
	DISK = N'F:\NISAR WORKSPACE\E-Logistics\DB-E-Logistics\eLogistics.bak' 
	WITH   REPLACE
GO

--backup db
BACKUP DATABASE [eLogistics] TO  
	DISK = N'F:\NISAR WORKSPACE\E-Logistics\DB-E-Logistics\eLogistics.bak' 
	WITH NOFORMAT
go
 -- format / noformat ► If you use FORMAT any existing contents get erased. / If you use NOFORMAT (the default) you can write multiple backups to the same file.