Mssql automatic backup... Pos ginetai?

[vespa_boy]

Kalimera,

 

exo enan server me leitourgiko MS Windows 2003 Small Business Server. Exei stimeno epano ton Sql Server 2000.

 

Thelo na perno auutomata oli tin vasi ena backup kathe vradi.

Xerei kaneis pos ginetai auto kai apo pou?

 

Euxaristo,

Apostolos

[bandito]

Kalimera' date='

 

exo enan server me leitourgiko MS Windows 2003 Small Business Server. Exei stimeno epano ton Sql Server 2000.

 

Thelo na perno auutomata oli tin vasi ena backup kathe vradi.

Xerei kaneis pos ginetai auto kai apo pou?

 

Euxaristo,

Apostolos[/quote']

 

Ανοιγεις τον entreprise manager, πας στον server που θες να παίρνεις backup, Διαλέγεις Management->BackUp, δεξι click Backup Database (μπορεις να του βαλεις και schedule εκεί).

[vespa_boy]

Euxaristo poli

Tha to dokimaso aurio kai tha sas enimeroso gia ta apotelesmata

 

Apostolos

[vespa_boy]

Ok

leitourgei kanonika

 

Thanx

[sotospez]

poli kalo ayto to backup poy leei o bandito giati kanei elexo kai tis basis

mporeis omos na kaneis kai ena allo poy emena me boithai poli

 

bazeis ayto se ena bat

 

net stop mssqlserver

 

set v=%date:~4,2%

 

rar a x:\%v%back.rar -m5 -os -r @files.txt -ilogx:\%v%back.log

h xcopy tin basi soy

 

 

net start mssqlserver

 

kai ayto to basi sto Scheduled Tasks ti windows

to kako den kanei elexo basis giati stamata to sql kai

meta to ksanakani start