NOT able to backup database

Question

NOT able to backup database

akashi

Valued Member

Points: 63
More actions
November 19, 2020 at 8:37 pm

#3811714

Hello All,
Facing a problem backing up a database. When i click on backup database in the select backup destination i do not see the Drive Z that has been setup where it has to backup. It shows only the C & D drive but when i try to locate then on the server it says path cannot be found. Not sure where these C & D drive are and its not showing the C drive on the server. Please help me on how can i find the Z drive & backup to this location. Thank you
NJPA

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247158 More actions · Answer 1

Those backup destinations are local (to the server) drives only, and I'm not sure whether that can be changed.

But you should be able to perform the backup to your network using T-SQL commands. Check this page for details and examples.

akashi Valued Member Points: 63 More actions · Answer 2

The problem im facing is that I cant locate the C drive & D drive it says path cannot be found & im unable to back up the file to the local C drive & O drive that are on the devices & drives

Attachments:

You must be logged in to view attached files.

Ant-Green SSC Guru Points: 113536 More actions · Answer 3

What is the goal here? To backup the database to the O drive? If so you cannot. SQL can only backup to drives which are local to the SQL server not remote drives unless you use UNC paths etc to provide backups to network locations.

The local drives to SQL are the local C drive and the local D drive. NOT your devices C or O drive.

You will need to backup to D, then use UNC to move the backup where it needs to be.

Just remember GDPR/HIPPA/SOX etc as moving databases around can have significant headaches for data breaches especially when moving data to end user devices and data breaches etc.

Jeff Moden SSC Guru Points: 1004591 More actions · Answer 4

Ant-Green wrote:

SQL can only backup to drives which are local to the SQL server not remote drives unless you use UNC paths etc to provide backups to network locations.

IIRC, you can cheat. If you want something mostly brainless, you can add an xp_CmdShell call in the SQL Server Startup to do a NET USE and Bob's your uncle.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

NOT able to backup database

Attachments:

Cookies on SQLServerCentral