بک آپ گرفتن از ساختار دیتابیس

--Step 1: Clone your database
--Here the "Demo" database is being copied as "Demo_Clone"
--Refresh SSMS's Object Explorer to see the new clone in the list of databases.
dbcc clonedatabase(Demo, Demo_Clone) with verify_clonedb;


--Step 2: Make the clone writable
--All clones are read-only by default, so this is required 
-- if you are going to use the clone for anything
alter database [Demo_Clone] set read_write;


/*
When developers or testers say they need a empty copy of the database 
without any data in it, what they really mean is that they want 
the schema AND all the basic reference data and config tables 
needed to run their code.
So at this point you can also copy in some reference data from the 
source database into your clone.
e.g.
insert into Demo_Clone..Accounts select * from Demo..Accounts
*/

--Step 3: Create a full backup
backup database [Demo_Clone] to disk = N'C:\temp\Demo_SchemaOnly_20220821.bak';


--Step 4: Remove the clone before the DBA includes it into maintenance plans 🙂
drop database [Demo_Clone];