使用SQL语句备份和还原数据库
使用SQL语句备份和还原数据库
/*备份*/
backup database databse1 to disk='c:/software/bak_database1_20220921.bak';
/*还原*/
restore database database2 from disk='c:/software/bak_database2_20220921.bak' with replace;
/*备份*/
backup database databse1 to disk='c:/software/bak_database1_20220921.bak';
/*还原*/
restore database database2 from disk='c:/software/bak_database2_20220921.bak' with replace;