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!
> >
> >
> >
Showing posts with label usb. Show all posts
Showing posts with label usb. Show all posts
Sunday, February 12, 2012
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]
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 USB 2.0 drive
Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
and cheap. The main server is running low on storage and want to offload my
online backups ... thought this would be a cheap solution. The only backups
happening during production are log backups which are only at most 2mb.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
Shaun,
I wouldn't do this in a corporate environment, but I might consider it
at home for pet projects. I always prefer to backup to local disk first,
and then xcopy/robocopy the file elsewhere, or get a tape backup agent
to grab it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Shaun Beane wrote:
> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
> and cheap. The main server is running low on storage and want to offload my
> online backups ... thought this would be a cheap solution. The only backups
> happening during production are log backups which are only at most 2mb.
>
|||I agree, but I'm running low on disk space and mr. big boss man doesn't want
to spend the money on an additional drive for the raid. I can get a USB 2.0
drive for about 100 bucks. I would be backing up to the local USB drive
instead of local internal disk. Then I would backup to tape from there.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eRV7zzMyEHA.4028@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Shaun,
> I wouldn't do this in a corporate environment, but I might consider it at
> home for pet projects. I always prefer to backup to local disk first, and
> then xcopy/robocopy the file elsewhere, or get a tape backup agent to grab
> it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Shaun Beane wrote:
|||For an additional 99 bucks, you could get MiniSQLBackup which ought to be
able to compress your backups to averagely 25% of their original size, and
then have it copy it to your USB drive upon completion. E.g. of syntax:
BACKUP mydb TO DISK = 'F:\Backups\db.bak' WITH COPYTO = 'U:\Backups\';
Or if you perform the backups manually, you could even use the free edition.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
and cheap. The main server is running low on storage and want to offload my
online backups ... thought this would be a cheap solution. The only backups
happening during production are log backups which are only at most 2mb.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
Shaun,
I wouldn't do this in a corporate environment, but I might consider it
at home for pet projects. I always prefer to backup to local disk first,
and then xcopy/robocopy the file elsewhere, or get a tape backup agent
to grab it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Shaun Beane wrote:
> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
> and cheap. The main server is running low on storage and want to offload my
> online backups ... thought this would be a cheap solution. The only backups
> happening during production are log backups which are only at most 2mb.
>
|||I agree, but I'm running low on disk space and mr. big boss man doesn't want
to spend the money on an additional drive for the raid. I can get a USB 2.0
drive for about 100 bucks. I would be backing up to the local USB drive
instead of local internal disk. Then I would backup to tape from there.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eRV7zzMyEHA.4028@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Shaun,
> I wouldn't do this in a corporate environment, but I might consider it at
> home for pet projects. I always prefer to backup to local disk first, and
> then xcopy/robocopy the file elsewhere, or get a tape backup agent to grab
> it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Shaun Beane wrote:
|||For an additional 99 bucks, you could get MiniSQLBackup which ought to be
able to compress your backups to averagely 25% of their original size, and
then have it copy it to your USB drive upon completion. E.g. of syntax:
BACKUP mydb TO DISK = 'F:\Backups\db.bak' WITH COPYTO = 'U:\Backups\';
Or if you perform the backups manually, you could even use the free edition.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
Backup to USB 2.0 drive
Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
and cheap. The main server is running low on storage and want to offload my
online backups ... thought this would be a cheap solution. The only backups
happening during production are log backups which are only at most 2mb.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.comShaun,
I wouldn't do this in a corporate environment, but I might consider it
at home for pet projects. I always prefer to backup to local disk first,
and then xcopy/robocopy the file elsewhere, or get a tape backup agent
to grab it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Shaun Beane wrote:
> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy
,
> and cheap. The main server is running low on storage and want to offload
my
> online backups ... thought this would be a cheap solution. The only backu
ps
> happening during production are log backups which are only at most 2mb.
>|||I agree, but I'm running low on disk space and mr. big boss man doesn't want
to spend the money on an additional drive for the raid. I can get a USB 2.0
drive for about 100 bucks. I would be backing up to the local USB drive
instead of local internal disk. Then I would backup to tape from there.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eRV7zzMyEHA.4028@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Shaun,
> I wouldn't do this in a corporate environment, but I might consider it at
> home for pet projects. I always prefer to backup to local disk first, and
> then xcopy/robocopy the file elsewhere, or get a tape backup agent to grab
> it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Shaun Beane wrote:|||For an additional 99 bucks, you could get MiniSQLBackup which ought to be
able to compress your backups to averagely 25% of their original size, and
then have it copy it to your USB drive upon completion. E.g. of syntax:
BACKUP mydb TO DISK = 'F:\Backups\db.bak' WITH COPYTO = 'U:\Backups';
Or if you perform the backups manually, you could even use the free edition.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
and cheap. The main server is running low on storage and want to offload my
online backups ... thought this would be a cheap solution. The only backups
happening during production are log backups which are only at most 2mb.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.comShaun,
I wouldn't do this in a corporate environment, but I might consider it
at home for pet projects. I always prefer to backup to local disk first,
and then xcopy/robocopy the file elsewhere, or get a tape backup agent
to grab it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Shaun Beane wrote:
> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy
,
> and cheap. The main server is running low on storage and want to offload
my
> online backups ... thought this would be a cheap solution. The only backu
ps
> happening during production are log backups which are only at most 2mb.
>|||I agree, but I'm running low on disk space and mr. big boss man doesn't want
to spend the money on an additional drive for the raid. I can get a USB 2.0
drive for about 100 bucks. I would be backing up to the local USB drive
instead of local internal disk. Then I would backup to tape from there.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eRV7zzMyEHA.4028@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Shaun,
> I wouldn't do this in a corporate environment, but I might consider it at
> home for pet projects. I always prefer to backup to local disk first, and
> then xcopy/robocopy the file elsewhere, or get a tape backup agent to grab
> it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Shaun Beane wrote:|||For an additional 99 bucks, you could get MiniSQLBackup which ought to be
able to compress your backups to averagely 25% of their original size, and
then have it copy it to your USB drive upon completion. E.g. of syntax:
BACKUP mydb TO DISK = 'F:\Backups\db.bak' WITH COPYTO = 'U:\Backups';
Or if you perform the backups manually, you could even use the free edition.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
Backup to USB 2.0 drive
Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
and cheap. The main server is running low on storage and want to offload my
online backups ... thought this would be a cheap solution. The only backups
happening during production are log backups which are only at most 2mb.
--
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.comShaun,
I wouldn't do this in a corporate environment, but I might consider it
at home for pet projects. I always prefer to backup to local disk first,
and then xcopy/robocopy the file elsewhere, or get a tape backup agent
to grab it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Shaun Beane wrote:
> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
> and cheap. The main server is running low on storage and want to offload my
> online backups ... thought this would be a cheap solution. The only backups
> happening during production are log backups which are only at most 2mb.
>|||I agree, but I'm running low on disk space and mr. big boss man doesn't want
to spend the money on an additional drive for the raid. I can get a USB 2.0
drive for about 100 bucks. I would be backing up to the local USB drive
instead of local internal disk. Then I would backup to tape from there.
--
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eRV7zzMyEHA.4028@.TK2MSFTNGP09.phx.gbl...
> Shaun,
> I wouldn't do this in a corporate environment, but I might consider it at
> home for pet projects. I always prefer to backup to local disk first, and
> then xcopy/robocopy the file elsewhere, or get a tape backup agent to grab
> it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Shaun Beane wrote:
>> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick,
>> easy, and cheap. The main server is running low on storage and want to
>> offload my online backups ... thought this would be a cheap solution.
>> The only backups happening during production are log backups which are
>> only at most 2mb.|||For an additional 99 bucks, you could get MiniSQLBackup which ought to be
able to compress your backups to averagely 25% of their original size, and
then have it copy it to your USB drive upon completion. E.g. of syntax:
BACKUP mydb TO DISK = 'F:\Backups\db.bak' WITH COPYTO = 'U:\Backups\';
Or if you perform the backups manually, you could even use the free edition.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
and cheap. The main server is running low on storage and want to offload my
online backups ... thought this would be a cheap solution. The only backups
happening during production are log backups which are only at most 2mb.
--
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.comShaun,
I wouldn't do this in a corporate environment, but I might consider it
at home for pet projects. I always prefer to backup to local disk first,
and then xcopy/robocopy the file elsewhere, or get a tape backup agent
to grab it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Shaun Beane wrote:
> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
> and cheap. The main server is running low on storage and want to offload my
> online backups ... thought this would be a cheap solution. The only backups
> happening during production are log backups which are only at most 2mb.
>|||I agree, but I'm running low on disk space and mr. big boss man doesn't want
to spend the money on an additional drive for the raid. I can get a USB 2.0
drive for about 100 bucks. I would be backing up to the local USB drive
instead of local internal disk. Then I would backup to tape from there.
--
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eRV7zzMyEHA.4028@.TK2MSFTNGP09.phx.gbl...
> Shaun,
> I wouldn't do this in a corporate environment, but I might consider it at
> home for pet projects. I always prefer to backup to local disk first, and
> then xcopy/robocopy the file elsewhere, or get a tape backup agent to grab
> it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Shaun Beane wrote:
>> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick,
>> easy, and cheap. The main server is running low on storage and want to
>> offload my online backups ... thought this would be a cheap solution.
>> The only backups happening during production are log backups which are
>> only at most 2mb.|||For an additional 99 bucks, you could get MiniSQLBackup which ought to be
able to compress your backups to averagely 25% of their original size, and
then have it copy it to your USB drive upon completion. E.g. of syntax:
BACKUP mydb TO DISK = 'F:\Backups\db.bak' WITH COPYTO = 'U:\Backups\';
Or if you perform the backups manually, you could even use the free edition.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
Friday, February 10, 2012
Backup to an USB Device
Hi:
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. However
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
Mitul
Hi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul
|||http://support.microsoft.com/kb/555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul
|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:
> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>
|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. However
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
Mitul
Hi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul
|||http://support.microsoft.com/kb/555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul
|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:
> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>
|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
Backup to an USB Device
Hi:
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. Howeve
r
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
MitulHi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. Howe
ver
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||http://support.microsoft.com/kb/555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:
> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
>
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. Howeve
r
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
MitulHi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. Howe
ver
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||http://support.microsoft.com/kb/555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:
> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
>
Backup to an USB Device
Hi:
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. However
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
MitulHi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||http://support.microsoft.com/kb/555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:
> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> > Hi:
> >
> > Can anyone help me with backing up SQL Server Databases to a Shared USB
> > Device over a Network. I am able to Map the USB Drive on the machine.
> > However
> > when I am trying to configure Backup using the Maintainence Wizard it does
> > not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> > Server SP1. Please let me know if this is possible.
> >
> > Thanks
> > Mitul
>|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
>> http://support.microsoft.com/kb/555128
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
>> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>> > Hi:
>> >
>> > Can anyone help me with backing up SQL Server Databases to a Shared USB
>> > Device over a Network. I am able to Map the USB Drive on the machine.
>> > However
>> > when I am trying to configure Backup using the Maintainence Wizard it
>> > does
>> > not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
>> > Server SP1. Please let me know if this is possible.
>> >
>> > Thanks
>> > Mitul
>>
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. However
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
MitulHi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||http://support.microsoft.com/kb/555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:
> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> > Hi:
> >
> > Can anyone help me with backing up SQL Server Databases to a Shared USB
> > Device over a Network. I am able to Map the USB Drive on the machine.
> > However
> > when I am trying to configure Backup using the Maintainence Wizard it does
> > not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> > Server SP1. Please let me know if this is possible.
> >
> > Thanks
> > Mitul
>|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
>> http://support.microsoft.com/kb/555128
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
>> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>> > Hi:
>> >
>> > Can anyone help me with backing up SQL Server Databases to a Shared USB
>> > Device over a Network. I am able to Map the USB Drive on the machine.
>> > However
>> > when I am trying to configure Backup using the Maintainence Wizard it
>> > does
>> > not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
>> > Server SP1. Please let me know if this is possible.
>> >
>> > Thanks
>> > Mitul
>>
Subscribe to:
Posts (Atom)