Backup And Recovery - SQL Server Forums

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 Programming

Backup And Recovery

Author

Topic

PeeJay2583
Starting Member

40 Posts

Posted - 2011-07-06 : 05:13:08

Hi Team,

I have to back up a database which is on a different server from my local machine is it possible as I only have the dbo rights to this database but no permission to create database?

If yes, its not allowing me to save the backup of that database at the path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
which is on my local machine or can I save at other location.

Need a workaround for backup. Any help would be appreciated.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-06 : 14:07:39

see

http://sqln.blogspot.com/2009/06/backing-up-directly-to-network-share.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-06 : 16:06:30

To add to that link, you'll need to specify a proper UNC path which means using a share. Do you have a share setup to your backup folder? If not, I would create one to make this easier. Otherwise, you'll need to use c$ admin share, which is not advisable.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources