How to take backup of database on external hard disk

[Former Member]

Hi Team,

We have a server with three instances SOX,GRC and SM2. We have attached

a external hard disk to take backup of database. While taking backup of

any database it gives error as attached. We can take backup of

transaction log on server's disk but not on external disk. Kindly have

a look on attached error and advice us.We are taking backup at sql

server level.

version: SQL SERVER 2005 64 bit

Regards,

Digambar

[Former Member]

This issue is resolved now as per previous comments.

Regards,

Digambar

[markus_doehr2]

You get which error?

Markus

[Former Member]

Hi,

I am getting following error while taking backup.

Syetem.Data.Sqlclient.sqlerror:writeon"I:\SM2FULLBACKUP\sm2dbfull" failed:112(There is not enough space on disk.)(microsoft.Sqlserver.Smo).

But we have 200 Gb disk space free on external drive, and other that database copy we can os files on this external disk.

Regards,

Digambar

[markus_doehr2]

How big is your database?

Markus

[Former Member]

Hi,

I have tried with 3 databse having size 55 gb,80 gb and 210 Gb . For all these database we are facing same problem. We have taken backup at enterprize manager and also SQL QUERY. And for both ways we are facing same error.

Regards,

Digambar

[markus_doehr2]

The HDD is 200 GB - but how much is FREE?

You can´t backup a 210 GB database on a 200 GB disk...

Markus

[Former Member]

Hi Markus,

>You can´t backup a 210 GB database on a 200 GB disk...

We learn a lot every day on these Expert Forums !

In fact, it could even be possible if it's the database enveloppe which is 210 GB and the actual data is less than 200 GB !

I dare to hope that it's not a production system which is backed up with an external disk...

Regards,

Olivier

[Former Member]

Please post the results:

use <SID>

go

exec sp_spaceused;

go

select file_id, type_desc, name, physical_name,state_desc, ((size*8)/1024) as 'size in MB'

from sys.database_files;

go

[Former Member]

The issue is resolved now issue is external disk needs NTFS partition.

Regards,

Digambar