China DOS Union

d:\data is the address of the database, e:\baksql\ is the address of the backup. Students who need to use it should change it themselves!
After each backup, it is automatically named with the backup time and written to the record file!

@echo Start backup: 

@echo Backup start time: %date% %time%

@net stop mssqlserver 

@net stop w3svc 

@net stop iisadmin /y

@xcopy d:\data e:\baksql\  /E /h 

@ren e:\baksql\Computer.mdf "%date%".mdf

@ren e:\baksql\Computer_log.LDF "%date%".LDF

@net start mssqlserver 

@net start w3svc 

@echo Backup completed!! 

@echo End backup time: %date% %time% 

@echo Backup time: %date% %time% >>e:\baksql\Backup time record.txt 

@cls

@exit

If the important data can also be transferred to another FTP machine

@echo Start backup: 

@echo Backup start time: %date% %time%

@net stop mssqlserver 

@net stop w3svc 

@net stop iisadmin /y

@xcopy d:\data e:\baksql\  /E /h 

@ren e:\baksql\Computer.mdf "%date%".mdf

@ren e:\baksql\Computer_log.LDF "%date%".LDF

@net start mssqlserver 

@net start w3svc 

@echo Backup completed!! 

@echo End backup time: %date% %time% 

@echo Backup time: %date% %time% >>e:\baksql\Backup time record.txt 

@echo Uploading data to X space...

@echo ftp.exe -s:C:\jh520.mmp

@cls

@exit

Create jh520.mmp under the C root and write the following code. Some things need to be changed by yourself!

open  FTPSEVER

USER		

PASSWORD

#bin 

cd  Backup document address

lcd e:\baksql\

put "%date%".mdf

put "%date%".LDF

bye 

Dear seniors, take a look. Where can it be optimized? Please give some suggestions!

Here are several questions:
1》Is there a size limit for the mdf file? Suppose there are several gigabytes of data under D:\data, can it also be written into the MDF file.
2》Can the same file be used as a backup file? Only write the changed and added ones each time, and don't generate too many files.
3》When putting it on FTP, do you need to manually enter the username and password each time? If so, can it be made into an automatic way because I want to use "Task Manager" to complete it automatically.

//When putting it on the FTP, do you need to manually enter the username and password each time?

No, the username and password are placed in the jh520.mmp file.

Thanks!Senior brother's suggestion. Since I need to back up this mdf which is only 30M and it's on the server, I run it only once a month through task scheduling, which is relatively stable! I have modified the following and implemented a batch script to solve all problems!

@echo Start backing up: 

@echo Backup start time: %date% %time%

@net stop mssqlserver 

@net stop w3svc 

@net stop iisadmin /y

@xcopy d:\data e:\baksql\  /E /h 

@ren e:\baksql\Computer.mdf "%date%".mdf

@ren e:\baksql\Computer_log.LDF "%date%".LDF

@net start mssqlserver 

@net start w3svc 

@echo Backup completed! 

@echo End backup time: %date% %time% 

@echo Backup time: %date% %time% >>e:\baksql\Backup time record.txt 

@echo Uploading data to X space...

(@echo open  FTPSEVER

@echo USER

@echo PASSWORD

@echo #bin 

@echo cd 网络备份文档地址

@echo lcd e:\baksql\

@echo put "%date%".mdf

@echo put "%date%".LDF

@echo bye)>%systemroot%\jh.exe

@echo ftp.exe -s:%systemroot%\jh.exe

@echo del %systemroot%/jh.exe

@echo@cls

@exit

@echo@cls There is something wrong here!

Learn and learn...

What program can open .mdf, .ldf files, and what code is included in jh.exe

.mdf, .ldf are for MSSQL databases
jh.exe can actually be opened with Notepad, it's not a WIN32 program at all
I made it like this to prevent others from opening it!

.mdf, .ldf are for MSSQL databases.

jh.exe can actually be opened with Notepad; it's not a WIN32 program at all. I made it like this to prevent others from opening it!

Can it be converted into common formats like ZIP, RAR? I still don't understand the meaning of this sentence.

jh.exe can actually be opened with Notepad; it's not a WIN32 program at all. I made it like this to prevent others from opening it!

Of course it's okay to reply to the upstairs. It's just a problem of the file extension! If you change *.txt to *.rar and then open it with Notepad, you can still see the content inside the txt.

Haha, when I was a network administrator in the past, I also did this kind of thing for recording backup times. But at that time, I was only given a few minutes, and the database was too large, about 1G per month, so there was no continuous saving function named by time.

Use the method of stopping operation to stop the reading and writing of the database file?

Actually, you can use the backup tool of mssql itself~

Learned, thanks, expert!

I've been writing batch scripts for 2 years, and the computer has been formatted N times. Fortunately, I found the old posts I posted online before!

How to write with SQL Server's own backup tool?

Just search for the usage of OSQL and SQLCMD.