SQL Server 2005 Backups

#1

I'm having an issue where there isn't apparently enough disk space on the
local C drive to create the temporary files used to create the backups. I'm
currently trying to use a USB hard drive to back up the SQL DB. My DB are
about 40GB with only around 20GB free on C: I have larger drives then this,
I need realtime db backups
Thankl

#2

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#4

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#5

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#6

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#7

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#8

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#9

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#10

John S. Pandolph (John S. Pandolph (AT) discussions (DOT) microsoft.com) writes:

Quote:

I'm having an issue where there isn't apparently enough disk space on
the local C drive to create the temporary files used to create the
backups. I'm currently trying to use a USB hard drive to back up the
SQL DB. My DB are about 40GB with only around 20GB free on C: I have
larger drives then this,

I am not aware of that BACKUP creates any temporary files. Exactly how
does your BACKUP command look like, and what error message do you get?

You can change the location of the %TEMP% and %TMP% in the System applet
in the Control Panel (Advanced tab->Environment variables.) I expect that
you need to restart SQL Server for it to take effect. If SQL Server ever
looks at these, which I doubt.

Quote:

I need realtime db backups

Not really sure what you mean with realtime backups, but if you need to be
able to restore to a point in time, you should back up the transaction log
frequently. It's usually enough to backup the database once a day.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server 2005 Backups

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

SQL Server 2005 Backups - 10-28-2008 , 02:55 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM

Re: SQL Server 2005 Backups - 10-28-2008 , 04:34 PM