niisar · August 29, 2015 14:06
diff --git a/db backup restore.sql b/db backup restore.sql
 -------------------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.
	-------------------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.