1-) MSSQL -  sql backup almak

BACKUP DATABASE ramazan_gulam TO DISK='D:\ramazan_gulam.bak'

2-)  sql backup almak silip tekrar oluşturur (WITH INIT ;)

BACKUP DATABASE ramazan_gulam TO DISK='D:\ramazan_gulam.bak' WITH INIT ;

kaynak : https://stackoverflow.com/questions/13709830/override-file-while-backup-database

3-)  sql backup almak .bat ile

-----rmosAcentexBat.bat-----

echo off

sqlcmd -E -S RAMBO -i C:\Users\ramazan\Desktop\rmosAcentexBat.sql

set /p delExit=Press the ENTER key to exit...:

-----rmosAcentexBat.sql----

BACKUP DATABASE rmosAcentex

TO DISK = 'C:\Users\ramazan\Google Drive (proje.ramazan.haber@gmail.com)\RMOS\1-) MSSQL - C#\1-) MSSQL - RmosAcentex\rmosAcentex.bak' WITH INIT;

4-)  sql backup yüklemek

RESTORE FILELISTONLY

FROM DISK = 'D:\3.0 Databases\DB.bak'

RESTORE DATABASE YourDB

FROM DISK = 'D:\3.0 Databases\DB.bak'

and you have to move appropriate mdf,ndf & ldf files using

 With Move 'primarydatafilename' To 'D:\DB\data.mdf',

 Move 'secondarydatafile'To 'D:\DB\data1.ndf',

 Move 'logfilename' To 'D:\DB\log.ldf'

USE [master]

RESTORE DATABASE [Demo01Crm] FROM  DISK = N'D:\SQL.23.06.2020\cc\Demo01Crm.bak'

WITH  FILE = 1,  

MOVE N'Demo01Crm'

TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Demo01Crm.mdf',  

MOVE N'Demo01Crm_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Demo01Crm_log.ldf',  

NOUNLOAD,  STATS = 5

GO