[MORJANA]

قبل ما تضيف حاجة هتاخود Backup و بعد ما تضيف
لو اشتغلت تمام تمسح الباكب القديم و تاخود Backup جديد

أعمل فولدر جديد في بارتيشن الـ C و سميه BACKUP كابيتال

و أستخدم الكويري دي
SHARD Backup

--------Full DB Backup Query By MORJANA--------[SHARD]
USE SRO_VT_SHARD;
GO
BACKUP DATABASE SRO_VT_SHARD
TO DISK = 'C:\BACKUP\SRO_VT_SHARD.Bak'
   WITH FORMAT,
      MEDIANAME = 'SRO_VT_SHARD',
      NAME = 'Full Backup of SRO_VT_SHARD';
GO

--------Full DB Backup Query By MORJANA--------[ACCOUNT]
USE SRO_VT_ACCOUNT;
GO
BACKUP DATABASE SRO_VT_ACCOUNT
TO DISK = 'C:\BACKUP\SRO_VT_ACCOUNT.Bak'
   WITH FORMAT,
      MEDIANAME = 'SRO_VT_ACCOUNT',
      NAME = 'Full Backup of SRO_VT_ACCOUNT';
GO

SHARDLOG Backup

--------Full DB Backup Query By MORJANA--------[SHARDLOG]
USE SRO_VT_SHARDLOG;
GO
BACKUP DATABASE SRO_VT_SHARDLOG
TO DISK = 'C:\BACKUP\SRO_VT_SHARDLOG.Bak'
   WITH FORMAT,
      MEDIANAME = 'SRO_VT_SHARDLOG',
      NAME = 'Full Backup of SRO_VT_SHARDLOG';
GO