I have connected to local and server database from local SqlServer 2005. How to take a backup from server database ?
Regards, kumar
A:
One option would be to setup a Maintenance Plan for your DB directly on the server that can have a DB backup performed on a defined schedule. You could also create a backup with T-SQL as shown below.
BACKUP DATABASE [MyDB] TO DISK = N'C:\dbbackup.bak'
WITH NOFORMAT, NOINIT, NAME = N'MyDB', SKIP, REWIND,
NOUNLOAD, STATS = 10
RSolberg
2010-03-25 06:12:20