Below steps to set backup database to mapping drive;
(1). please make sure the service of MSSQL Server instant not logon as Local Account:
- go to control panel - services
- select MSSQL Server service then right click
- changes logon from local to administrator or same domain as login to mapping drive
- restart the services to make effect
(2) . from query analizer of Ms. SQL Server: use below script;
BACKUP DATABASE yourDBname TO DISK ='\\192.168.100.15\yourDBname.bak'
to best performance: please use LAN Card and SWITCH 1GB for server and client
Thursday, October 21, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment