Skip to main content

Posts

Showing posts from August, 2010

Backup SQL Server DB to network drive

here the step that needed: 1. make sure SQL SERVER SERVICE in run under same account and password between SQL SERVER machine and Network Machine ex: Network Machine: \\192.168.1.5\f$ - share the f$ in 192.168.1.5 - set security for the share for : user1 with pwd: pwd1 SQL Server machine: - create user1 with pwd: pwd1 if it doesn't exist - setting the Service for SQL SERVER to run under: user1 account with pwd: pwd1(Log On As) - execute the script 2. backup script BACKUP DATABASE [DB_LIVE] TO DISK = '\\192.168.1.5\f$\backup_db.bak' WITH NOFORMAT, NOINIT, NAME = N'SRM_LIVE-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 u can set it to run for jobs too see u