Backup to USB drive failing

We have a SQL Server (2000, Win2K) that used to backup to a tape drive. The
tape drive was connected through our Domain Controller. DC crashed. As
emergency solution, a 256GB external USB drive was attached to the SQL
Server, and appears in structure as Drive F:\.
I can manually backup my TLog to the USB drive, but scheduled TLog backups
don't even launch, let alone fail.
I can launch a manual Full Database backup, but it fails, error 112, not
enough disk space. My db is only 50GB, and I have 230GB free on my external
USB drive.
Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
launch, and why the Full backup says I am out of space?
We are using the Administrator login, with full permissions.
Thanks!Make sure your drive is formatted using NTFS, not FAT32.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Duane" <Duane@.discussions.microsoft.com> wrote in message
news:346BBF00-0EFA-4929-A452-DACF33FDE7C0@.microsoft.com...
> We have a SQL Server (2000, Win2K) that used to backup to a tape drive.
> The
> tape drive was connected through our Domain Controller. DC crashed. As
> emergency solution, a 256GB external USB drive was attached to the SQL
> Server, and appears in structure as Drive F:\.
> I can manually backup my TLog to the USB drive, but scheduled TLog backups
> don't even launch, let alone fail.
> I can launch a manual Full Database backup, but it fails, error 112, not
> enough disk space. My db is only 50GB, and I have 230GB free on my
> external
> USB drive.
> Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
> launch, and why the Full backup says I am out of space?
> We are using the Administrator login, with full permissions.
> Thanks!|||Geoff, thanks. It is FAT32, and we will reformat Thursday and try again.
HOWEVER, I still have the issue of why my scheduled backups don't even
launch. This shouldn't have anything to do with formatting, as I can
manually backup a TLog, but it doesn't even launch when scheduled.
Suggestions?
Thanks,
Duane
"Geoff N. Hiten" wrote:
> Make sure your drive is formatted using NTFS, not FAT32.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Duane" <Duane@.discussions.microsoft.com> wrote in message
> news:346BBF00-0EFA-4929-A452-DACF33FDE7C0@.microsoft.com...
> > We have a SQL Server (2000, Win2K) that used to backup to a tape drive.
> > The
> > tape drive was connected through our Domain Controller. DC crashed. As
> > emergency solution, a 256GB external USB drive was attached to the SQL
> > Server, and appears in structure as Drive F:\.
> >
> > I can manually backup my TLog to the USB drive, but scheduled TLog backups
> > don't even launch, let alone fail.
> >
> > I can launch a manual Full Database backup, but it fails, error 112, not
> > enough disk space. My db is only 50GB, and I have 230GB free on my
> > external
> > USB drive.
> >
> > Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
> > launch, and why the Full backup says I am out of space?
> >
> > We are using the Administrator login, with full permissions.
> >
> > Thanks!
>
>|||"Duane" <Duane@.discussions.microsoft.com> wrote in message
news:019B2438-DC3D-41D9-992F-C42B2CA300A4@.microsoft.com...
> Geoff, thanks. It is FAT32, and we will reformat Thursday and try again.
> HOWEVER, I still have the issue of why my scheduled backups don't even
> launch. This shouldn't have anything to do with formatting, as I can
> manually backup a TLog, but it doesn't even launch when scheduled.
GENERALLY I've seen that when folks backup to a shared drive and don't have
permissions right.
But if this is a local drive, that shouldn't be an issue... hmm, unless
somehow the user account SQL Admin is running under hasn't picked up the new
drive letter?
Might want to try cycling SQL Admin.
> Suggestions?
> Thanks,
> Duane
> "Geoff N. Hiten" wrote:
> > Make sure your drive is formatted using NTFS, not FAT32.
> >
> > --
> > Geoff N. Hiten
> > Senior Database Administrator
> > Microsoft SQL Server MVP
> >
> >
> > "Duane" <Duane@.discussions.microsoft.com> wrote in message
> > news:346BBF00-0EFA-4929-A452-DACF33FDE7C0@.microsoft.com...
> > > We have a SQL Server (2000, Win2K) that used to backup to a tape
drive.
> > > The
> > > tape drive was connected through our Domain Controller. DC crashed.
As
> > > emergency solution, a 256GB external USB drive was attached to the SQL
> > > Server, and appears in structure as Drive F:\.
> > >
> > > I can manually backup my TLog to the USB drive, but scheduled TLog
backups
> > > don't even launch, let alone fail.
> > >
> > > I can launch a manual Full Database backup, but it fails, error 112,
not
> > > enough disk space. My db is only 50GB, and I have 230GB free on my
> > > external
> > > USB drive.
> > >
> > > Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
> > > launch, and why the Full backup says I am out of space?
> > >
> > > We are using the Administrator login, with full permissions.
> > >
> > > Thanks!
> >
> >
> >

Backup to USB drive failing

We have a SQL Server (2000, Win2K) that used to backup to a tape drive. The
tape drive was connected through our Domain Controller. DC crashed. As
emergency solution, a 256GB external USB drive was attached to the SQL
Server, and appears in structure as Drive F:\.
I can manually backup my TLog to the USB drive, but scheduled TLog backups
don't even launch, let alone fail.
I can launch a manual Full Database backup, but it fails, error 112, not
enough disk space. My db is only 50GB, and I have 230GB free on my external
USB drive.
Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
launch, and why the Full backup says I am out of space?
We are using the Administrator login, with full permissions.
Thanks!Make sure your drive is formatted using NTFS, not FAT32.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Duane" <Duane@.discussions.microsoft.com> wrote in message
news:346BBF00-0EFA-4929-A452-DACF33FDE7C0@.microsoft.com...
> We have a SQL Server (2000, Win2K) that used to backup to a tape drive.
> The
> tape drive was connected through our Domain Controller. DC crashed. As
> emergency solution, a 256GB external USB drive was attached to the SQL
> Server, and appears in structure as Drive F:\.
> I can manually backup my TLog to the USB drive, but scheduled TLog backups
> don't even launch, let alone fail.
> I can launch a manual Full Database backup, but it fails, error 112, not
> enough disk space. My db is only 50GB, and I have 230GB free on my
> external
> USB drive.
> Any ideas why my scheduled (Maintenance Plan) TLog backups don't even
> launch, and why the Full backup says I am out of space?
> We are using the Administrator login, with full permissions.
> Thanks!|||Geoff, thanks. It is FAT32, and we will reformat Thursday and try again.
HOWEVER, I still have the issue of why my scheduled backups don't even
launch. This shouldn't have anything to do with formatting, as I can
manually backup a TLog, but it doesn't even launch when scheduled.
Suggestions?
Thanks,
Duane
"Geoff N. Hiten" wrote:

> Make sure your drive is formatted using NTFS, not FAT32.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Duane" <Duane@.discussions.microsoft.com> wrote in message
> news:346BBF00-0EFA-4929-A452-DACF33FDE7C0@.microsoft.com...
>
>|||"Duane" <Duane@.discussions.microsoft.com> wrote in message
news:019B2438-DC3D-41D9-992F-C42B2CA300A4@.microsoft.com...
> Geoff, thanks. It is FAT32, and we will reformat Thursday and try again.
> HOWEVER, I still have the issue of why my scheduled backups don't even
> launch. This shouldn't have anything to do with formatting, as I can
> manually backup a TLog, but it doesn't even launch when scheduled.
GENERALLY I've seen that when folks backup to a shared drive and don't have
permissions right.
But if this is a local drive, that shouldn't be an issue... hmm, unless
somehow the user account SQL Admin is running under hasn't picked up the new
drive letter?
Might want to try cycling SQL Admin.
[vbcol=seagreen]
> Suggestions?
> Thanks,
> Duane
> "Geoff N. Hiten" wrote:
>
drive.[vbcol=seagreen]
As[vbcol=seagreen]
backups[vbcol=seagreen]
not[vbcol=seagreen]

Backup to Unix/Linux

Hi, I have data sitting on an external MSSQL 2000 host that needs to be
backed up. Currently I'm using DTS on a Win2k desktop, but this isn't really
practical as this machine is used as a workstation.
Has anyone heard of any methods to backup to a Unix/Linux server?
Any help would be appreciated.
TIA JoIf the server can see a volume on the network then it should be possible to
write to it. If Windows can't see it then SQL Server won't either.
--
David Portas
SQL Server MVP
--|||"David Portas" wrote:
> If the server can see a volume on the network then it should be possible to
> write to it. If Windows can't see it then SQL Server won't either.
> --
> David Portas
> SQL Server MVP
> --
>
Thanks for the reply David. I can create a Samba share, but do you know of
any scripts or tools that can copy pull the data down? I only have DTS access
to my database on the hosting provider.
I realise most people have access to a Windows server, just wondering if
anyone had done/tried/heard of it.
Jo|||You can create a DTS package with one connection and a T-sql task... The
T-sql task would be a backup command ie.
backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
init
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jo" <Jo@.discussions.microsoft.com> wrote in message
news:E1948BEF-BBF2-45A0-8695-14D766726225@.microsoft.com...
>
> "David Portas" wrote:
> > If the server can see a volume on the network then it should be possible
to
> > write to it. If Windows can't see it then SQL Server won't either.
> >
> > --
> > David Portas
> > SQL Server MVP
> > --
> >
> Thanks for the reply David. I can create a Samba share, but do you know of
> any scripts or tools that can copy pull the data down? I only have DTS
access
> to my database on the hosting provider.
> I realise most people have access to a Windows server, just wondering if
> anyone had done/tried/heard of it.
> Jo

Backup to Unix/Linux

Hi, I have data sitting on an external MSSQL 2000 host that needs to be
backed up. Currently I'm using DTS on a Win2k desktop, but this isn't really
practical as this machine is used as a workstation.
Has anyone heard of any methods to backup to a Unix/Linux server?
Any help would be appreciated.
TIA Jo
If the server can see a volume on the network then it should be possible to
write to it. If Windows can't see it then SQL Server won't either.
David Portas
SQL Server MVP
|||"David Portas" wrote:

> If the server can see a volume on the network then it should be possible to
> write to it. If Windows can't see it then SQL Server won't either.
> --
> David Portas
> SQL Server MVP
> --
>
Thanks for the reply David. I can create a Samba share, but do you know of
any scripts or tools that can copy pull the data down? I only have DTS access
to my database on the hosting provider.
I realise most people have access to a Windows server, just wondering if
anyone had done/tried/heard of it.
Jo
|||You can create a DTS package with one connection and a T-sql task... The
T-sql task would be a backup command ie.
backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
init
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jo" <Jo@.discussions.microsoft.com> wrote in message
news:E1948BEF-BBF2-45A0-8695-14D766726225@.microsoft.com...[vbcol=seagreen]
>
> "David Portas" wrote:
to
> Thanks for the reply David. I can create a Samba share, but do you know of
> any scripts or tools that can copy pull the data down? I only have DTS
access
> to my database on the hosting provider.
> I realise most people have access to a Windows server, just wondering if
> anyone had done/tried/heard of it.
> Jo
|||"Wayne Snyder" wrote:

> You can create a DTS package with one connection and a T-sql task... The
> T-sql task would be a backup command ie.
> backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
> init
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
"Wayne Snyder" wrote:

> You can create a DTS package with one connection and a T-sql task... The
> T-sql task would be a backup command ie.
> backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
> init
Thanks for the reply Wayne. I'm still learning, but I'm not sure if I have
access to do this (this command would have to be run on the server?). The
database is sitting on a web host, I only have access (that I'm aware of?) by
using Enterprise Manager. I'm don't often work with MSSQL, but what I
initially thought was using a Perl or shell script that connects to the
correct port and runs some commands to initiate a backup. I was hoping that
someone had already written one too. I'm probably crazy :-P
The site I'm doing this for only has a Linux server that gets backed up
daily. Thanks for the help and patience guys :-)
Jo

Backup to Unix/Linux

Hi, I have data sitting on an external MSSQL 2000 host that needs to be
backed up. Currently I'm using DTS on a Win2k desktop, but this isn't really
practical as this machine is used as a workstation.
Has anyone heard of any methods to backup to a Unix/Linux server?
Any help would be appreciated.
TIA JoIf the server can see a volume on the network then it should be possible to
write to it. If Windows can't see it then SQL Server won't either.
David Portas
SQL Server MVP
--|||"David Portas" wrote:

> If the server can see a volume on the network then it should be possible t
o
> write to it. If Windows can't see it then SQL Server won't either.
> --
> David Portas
> SQL Server MVP
> --
>
Thanks for the reply David. I can create a Samba share, but do you know of
any scripts or tools that can copy pull the data down? I only have DTS acces
s
to my database on the hosting provider.
I realise most people have access to a Windows server, just wondering if
anyone had done/tried/heard of it.
Jo|||You can create a DTS package with one connection and a T-sql task... The
T-sql task would be a backup command ie.
backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
init
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jo" <Jo@.discussions.microsoft.com> wrote in message
news:E1948BEF-BBF2-45A0-8695-14D766726225@.microsoft.com...
>
> "David Portas" wrote:
>
to[vbcol=seagreen]
> Thanks for the reply David. I can create a Samba share, but do you know of
> any scripts or tools that can copy pull the data down? I only have DTS
access
> to my database on the hosting provider.
> I realise most people have access to a Windows server, just wondering if
> anyone had done/tried/heard of it.
> Jo|||"Wayne Snyder" wrote:

> You can create a DTS package with one connection and a T-sql task... The
> T-sql task would be a backup command ie.
> backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
> init
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
"Wayne Snyder" wrote:

> You can create a DTS package with one connection and a T-sql task... The
> T-sql task would be a backup command ie.
> backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
> init
Thanks for the reply Wayne. I'm still learning, but I'm not sure if I have
access to do this (this command would have to be run on the server?). The
database is sitting on a web host, I only have access (that I'm aware of?) b
y
using Enterprise Manager. I'm don't often work with MSSQL, but what I
initially thought was using a PERL or shell script that connects to the
correct port and runs some commands to initiate a backup. I was hoping that
someone had already written one too. I'm probably crazy :-P
The site I'm doing this for only has a Linux server that gets backed up
daily. Thanks for the help and patience guys :-)
Jo