database back up file is not creating

Question

 Hi ,

I am doing back up for my database but back file is not creating in folder location.

I done back up through GUI and command also both getting successful message but file is not creating.

I have given full access to folder location and by using query i can see back file is created in history.

can you please guide me how to troubleshoot ?

Regards,

Kapil.

Answer 1

Please check the folder location on Server and not on your local machine. :)

---

--------------------------------------------------------

Surender Singh Bhadauria

My Blog

 

Answer 2

Are you doing backup to a network location or a local drive on the server?

---

Satheesh

Answer 3

Its highly unlikely that you give backup comamnd ,it completes successfully and you dont see backup file.

1.In backup coammand check for Didc'location' ,this location.Iassume it will be NAS (network storage).Some shared location

2. It is not permission issue, i hink you are giving wrong location.

Can you post your query here and also confirm the location your are giving is not some TAPE or NAS but local drive

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 4

Do you mean the command is completed successfully but file is not created? 

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 5

i am doing back up in my location machine and successfully message is coming but file is not creating 

Answer 6

Hi,

You have to look on the machine where the SQL Sever is running.

---

Satheesh

Answer 7

I have ran this command.

BACKUP DATABASE EsbExceptionDb TO DISK='E:\SQLBackups\D1\DATA\MyDatabase.bak'

Processed 256 pages for database 'EsbExceptionDb', file 'EsbExceptionDb_SysData' on file 3.
Processed 1 pages for database 'EsbExceptionDb', file 'EsbExceptionDb_Log' on file 3.
BACKUP DATABASE successfully processed 257 pages in 0.139 seconds (14.444 MB/sec).

Answer 8

Could you try a different location?

---

Satheesh

Answer 9

Trying this location will be even more better..I gave you location for 2008 R2..Just browse to folder backup for any version of sql server

%System drive%:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 10

The back up files are creating in server location

is it possible to change to local drive ?

Answer 11

yes it is possible to , but create a mapped drive to your local drive in your SQL server machine and do.

---

Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 12

The back up files are creating in server location

is it possible to change to local drive ?

Make sure the account with which ur logging has read ,write, modify permission on drive where you are taking backup.You can also add your Account in security folder of drive and give permission.RK on drive go to security tab and add the account.If you are not able to do ask you windows admin to give you required rights

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 13

you can backup to a shared network location

BACKUP DATABASE EsbExceptionDb TO DISK='<<network drive>>'

---

Satheesh