MuServeriem Kuri Stav Uz LocalDisk(D)
1.Solis
Izveido mapi iek6 D:\MuServer\, Mapes Nosaukums ''DBAutoBackUp''
2.Solis
6o SQL Job Uzstadit pec pamacibas http://murders.times.lv >>Ka Uzstadit autoresetu!
Quote
DECLARE @ads varchar(70)
SET @ads = N'D:\MuServer\DBAutoBackUp\'+REPLACE(REPLACE(CAST(getdate() AS varchar), ' ', '_'), ':', '_')
SELECT @ads
BACKUP DATABASE [MuOnline] TO DISK = @ads WITH INIT , NOUNLOAD , NAME = N'MuOnline AutoBackUp', NOSKIP , STATS = 10, NOFORMAT
->Shedule noradit laiku pec cik ilga laika datubazes automatiski saglabajas! ( man stav ik paec 3 stundam)
MuServeriem Kuri Stav Uz LocalDisk©
->veikt tos pa6us Solus kAs ir Aprakstiti sakuma!
-> Izmantot 6itadu SQL Scriptu!
Quote
DECLARE @ads varchar(70)
SET @ads = N'C:\MuServer\DBAutoBackUp\'+REPLACE(REPLACE(CAST(getdate() AS varchar), ' ', '_'), ':', '_')
SELECT @ads
BACKUP DATABASE [MuOnline] TO DISK = @ads WITH INIT , NOUNLOAD , NAME = N'MuOnline AutoBackUp', NOSKIP , STATS = 10, NOFORMAT
Darbojas 100% pac testeju!
