DATABASE BACKUP ON SEPARATE SERVER

[DBA2RELOADED]

How can I backup a database on a separate server? I mapped the drive on the current Server, but it won't give me that option when selecting the drive on where I want to backup the files. Thanks!

 

[tlbroadbent]

SQL Server runs in its own context and cannot "see" drives mapped in windows. You can use the UNC to backup to a remote server - \\servername\share\folder\filename.bak.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[DBA2RELOADED]

Great! Thanks. I have a follow up question. If I were given a user access and not an administrator access to the remote server, how can I backup my database to the remote server. Thanks.

 

[tlbroadbent]

The login must have write permission on the remote server folder.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[DBA2RELOADED]

I'm getting this error, any advise?

BackupDiskFile::CreateMedia: Backup device '\\servername\d$\MSSQL7\BACKUP\DBname.BAK' failed to create. Operating system error = 5(Access is denied.).

Access Denied -> Don't know why, because when I
Start/RUN/Open \\servername\d$
I have full control permission.

Thanks!

 

[SQLBill]

But do you have access to that specific directory (MSSQL7\BACKUP)? Sometimes you can have access to a share, but not all the directories within that share.

-SQLBill

 

[tlbroadbent]

Does the SQL Server startup account have permissions? When you run the backup statement, it runs on the server. It is not running with your account.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[DBA2RELOADED]

Thanks a lot. It's working now. I changed the SQL Server startup account to startup on the domain account. Again, THANKS!