Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Backup

Author  Topic 

itgeek
Starting Member

1 Post

Posted - 2009-12-16 : 09:33:12
Quick Question, Backup Destination does it have to be a domain Member and have an Sql Instance Running on it?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-12-16 : 10:29:17
no. sql service account just needs permission to write to the destination
Go to Top of Page

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-12-17 : 07:02:03
-- First make sure that sql server services are started with Domain Account
-- Then run following statement.


BACKUP DATABASE AdventureWorks
TO DISK = N'\\YourDestinatinFolder\AdventureWorks.BAK'
Go to Top of Page
   

- Advertisement -