Membuat Job di sql server 2008 dan Memperbaiki sql browser tidak bisa start

CARA MEMBUAT JOB PADA SQL SERVER 2008

Membuat Job di sql server 2008 dan Memperbaiki sql browser tidak bisa start
atau sql server tidak bisa start


1.Query membuat job pada sql server 2008

BACKUP Database [PurchasingIndonesia]
TO  DISK = N'E:\sance\Database Sance\Backup job\PurchasingIndonesia.bak';
go
BACKUP Database [sance]
TO  DISK = N'E:\sance\Database Sance\Backup job\sance.bak';
go
backup database[dbSance]
TO  DISK = N'E:\sance\Database Sance\Backup job\dbsance.bak';
go

https://solutioncenter.apexsql.com/how-to-create-a-sql-server-scheduled-backup/


B.Backup Database Di sql server 2008

http://daffnbill.blogspot.com/2017/03/cara-membuat-schedule-backup-otomatis.html

Step Backup ERP1

1.Mengcopy Data

BACKUP Database [InventoryERP-VV-INDONESIA]

TO  DISK = N'H:\Backup ERP\InventoryERP-VV-INDONESIA.bak';

go

BACKUP Database [MedanCostProcessERP]

TO  DISK = N'H:\Backup ERP\MedanCostProcessERP.bak';

go

backup database[NAUGHTY-MEDAN]

TO  DISK = N'H:\Backup ERP\NAUGHTY-MEDAN.bak';

go

backup database[PurchasingERP-MEDAN]

TO  DISK = N'H:\Backup ERP\PurchasingERP-MEDAN.bak';

go

backup database[StoreERP-VV-INDONESIA]

TO  DISK = N'H:\Backup ERP\StoreERP-VV-INDONESIA.bak';

go

2.Mereplace Data

BACKUP Database [InventoryERP-VV-INDONESIA]

TO  DISK = N'H:\Backup ERP\InventoryERP-VV-INDONESIA.bak' WITH INIT;

go

BACKUP Database [MedanCostProcessERP]

TO  DISK = N'H:\Backup ERP\MedanCostProcessERP.bak' WITH INIT;

go

backup database[NAUGHTY-MEDAN]

TO  DISK = N'H:\Backup ERP\NAUGHTY-MEDAN.bak' WITH INIT;

go

backup database[PurchasingERP-MEDAN]

TO  DISK = N'H:\Backup ERP\PurchasingERP-MEDAN.bak' WITH INIT;

go

backup database[StoreERP-VV-INDONESIA]

TO  DISK = N'H:\Backup ERP\StoreERP-VV-INDONESIA.bak' WITH INIT;

go

Sql Browser not running

https://databasesance3.blogspot.com/

Cara Mengatasi Error "The request failed or the service did not respond in a timely fashion... "

https://databasesance2.blogspot.com/

Mengubah Database Read Only Menjadi Read Write

https://databasesance1.blogspot.com/