BACKUP SQL SERVER DATABASES

I have setup a backup device that backs up a databases daily but i want to
overwrite the data weekly right now its has two months of data in the device.
How do i set it to overwrite
Use the INIT option of the BACKUP command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lyle" <lyle@.discussions.microsoft.com> wrote in message
news:683AAFF2-4F8C-44F3-A195-F85A9881C047@.microsoft.com...
> I have setup a backup device that backs up a databases daily but i want to
> overwrite the data weekly right now its has two months of data in the device.
> How do i set it to overwrite

backup question

sql server 2000 sp3.
I would like to backup a database frequently, maybe every 1/2 hour. I would
like to backup to a file. Can a create a backup device (file) on a network
server so the backup goes directly to another server? Or do I have to backup
to the lcoal hard drive and schedule a script to copy it off the drive?
any info is appreciated. thanks.What you can do is map a network drive on your server, then you can
create a backup device on that mapped drive
Eric Li
SQL DBA
MCDBA
djc wrote:

> sql server 2000 sp3.
> I would like to backup a database frequently, maybe every 1/2 hour. I woul
d
> like to backup to a file. Can a create a backup device (file) on a network
> server so the backup goes directly to another server? Or do I have to back
up
> to the lcoal hard drive and schedule a script to copy it off the drive?
> any info is appreciated. thanks.
>|||If the service account for the SQL Server service has permissions on the dri
ve, then yes, you can use a
network drive. Address it using UNC naming.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...[vbc
ol=seagreen]
> sql server 2000 sp3.
> I would like to backup a database frequently, maybe every 1/2 hour. I woul
d
> like to backup to a file. Can a create a backup device (file) on a network
> server so the backup goes directly to another server? Or do I have to back
up
> to the lcoal hard drive and schedule a script to copy it off the drive?
> any info is appreciated. thanks.
>[/vbcol]|||Hi,
Do not perform the FULL database backup every 30 minutes. This will create
issue once your
database grow big. I recommend you to do a transaction log backup every 30
minutes to a remote server and
perform the FULL database backup once every night.
Prerequsites to do a backup remotely
---
There are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
Transaction log backup
--
BACKUP log <dbname> to disk='\\computername\sharename\dbname_tr
an1.trn'
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
MCDBA
"djc" <noone@.nowhere.com> wrote in message
news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...
> sql server 2000 sp3.
> I would like to backup a database frequently, maybe every 1/2 hour. I
would
> like to backup to a file. Can a create a backup device (file) on a network
> server so the backup goes directly to another server? Or do I have to
backup
> to the lcoal hard drive and schedule a script to copy it off the drive?
> any info is appreciated. thanks.
>|||thats what I was thinking. Will I need to log on as the SQLServer Service
account and map the drive? In other words, I was concerned that if I map the
drive under my account it would not exist under the context of the scheduled
task?
"Eric.Li" <anonymous@.microsoftnews.org> wrote in message
news:eB2F$XxUEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> What you can do is map a network drive on your server, then you can
> create a backup device on that mapped drive
> --
> Eric Li
> SQL DBA
> MCDBA
> djc wrote:
>
would[vbcol=seagreen]
network[vbcol=seagreen]
backup[vbcol=seagreen]|||thanks for the reply.
can I do this through GUI Enterprise manager? (under database, management,
backup) I am not very familiar with TSQL at this point.
I think I tried to create a new backup device using a UNC name and it would
not let me? (which leads me to believe what your refering to has to be done
using TSQL)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u6BUZaxUEHA.644@.tk2msftngp13.phx.gbl...
> If the service account for the SQL Server service has permissions on the
drive, then yes, you can use a
> network drive. Address it using UNC naming.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...
would[vbcol=seagreen]
network[vbcol=seagreen]
backup[vbcol=seagreen]
>|||thanks for the reply. Is using TSQL the only way to accomplish this? or
could I use enterprise manager gui. I'm not that familiar with TSQL at this
point.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OfzbFf4UEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Do not perform the FULL database backup every 30 minutes. This will create
> issue once your
> database grow big. I recommend you to do a transaction log backup every 30
> minutes to a remote server and
> perform the FULL database backup once every night.
> Prerequsites to do a backup remotely
> ---
> There are Few Pre requisites to do backup remotely;
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
> Now you can execute the Backup script with UNC path
> BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak'
with
> init
> Transaction log backup
> --
> BACKUP log <dbname> to disk='\\computername\sharename\dbname_tr
an1.trn'
> Note:
> Backup to remote machine will not work if you start SQL server using Local
> system account
> Thanks
> Hari
> MCDBA
>
>
> "djc" <noone@.nowhere.com> wrote in message
> news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...
> would
network[vbcol=seagreen]
> backup
>|||Yep, you can create the backup device using EM (I just tried it), you just h
ave to type the full UNC name, and
ignore the warning that EM cannot confirm that you have access to the file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:u1np1n5UEHA.1356@.TK2MSFTNGP09.phx.gbl...[vbc
ol=seagreen]
> thanks for the reply.
> can I do this through GUI Enterprise manager? (under database, management,
> backup) I am not very familiar with TSQL at this point.
> I think I tried to create a new backup device using a UNC name and it woul
d
> not let me? (which leads me to believe what your refering to has to be don
e
> using TSQL)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:u6BUZaxUEHA.644@.tk2msftngp13.phx.gbl...
> drive, then yes, you can use a
> news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...
> would
> network
> backup
>[/vbcol]|||I should have added that your problem can very well be permissions problem.
Check out the service account for
SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message
news:ef5Wi15UEHA.544@.TK2MSFTNGP11.phx.gbl...
> Yep, you can create the backup device using EM (I just tried it), you just have to
type the full UNC name,
and
> ignore the warning that EM cannot confirm that you have access to the file
.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message news:u1np1n5UEHA.1356@.TK2MSFTNG
P09.phx.gbl...
>|||ok. Great. I had only very quickly given it one attempt before... and I had
an administrative share in the path (\\server\d$ ...etc...) so maybe that
had something to do with it as well. I will also setup the appropriate
permissions for the sql service account... Thanks for the info!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ef5Wi15UEHA.544@.TK2MSFTNGP11.phx.gbl...
> Yep, you can create the backup device using EM (I just tried it), you just
have to type the full UNC name, and
> ignore the warning that EM cannot confirm that you have access to the
file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:u1np1n5UEHA.1356@.TK2MSFTNGP09.phx.gbl...
management,[vbcol=seagreen]
would[vbcol=seagreen]
done[vbcol=seagreen]
in[vbcol=seagreen]
the[vbcol=seagreen]
I[vbcol=seagreen]
to[vbcol=seagreen]
drive?[vbcol=seagreen]
>

backup question

sql server 2000 sp3.
I would like to backup a database frequently, maybe every 1/2 hour. I would
like to backup to a file. Can a create a backup device (file) on a network
server so the backup goes directly to another server? Or do I have to backup
to the lcoal hard drive and schedule a script to copy it off the drive?
any info is appreciated. thanks.
What you can do is map a network drive on your server, then you can
create a backup device on that mapped drive
Eric Li
SQL DBA
MCDBA
djc wrote:

> sql server 2000 sp3.
> I would like to backup a database frequently, maybe every 1/2 hour. I would
> like to backup to a file. Can a create a backup device (file) on a network
> server so the backup goes directly to another server? Or do I have to backup
> to the lcoal hard drive and schedule a script to copy it off the drive?
> any info is appreciated. thanks.
>
|||If the service account for the SQL Server service has permissions on the drive, then yes, you can use a
network drive. Address it using UNC naming.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...
> sql server 2000 sp3.
> I would like to backup a database frequently, maybe every 1/2 hour. I would
> like to backup to a file. Can a create a backup device (file) on a network
> server so the backup goes directly to another server? Or do I have to backup
> to the lcoal hard drive and schedule a script to copy it off the drive?
> any info is appreciated. thanks.
>
|||Hi,
Do not perform the FULL database backup every 30 minutes. This will create
issue once your
database grow big. I recommend you to do a transaction log backup every 30
minutes to a remote server and
perform the FULL database backup once every night.
Prerequsites to do a backup remotely
There are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
Transaction log backup
BACKUP log <dbname> to disk='\\computername\sharename\dbname_tran1.trn'
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
MCDBA
"djc" <noone@.nowhere.com> wrote in message
news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...
> sql server 2000 sp3.
> I would like to backup a database frequently, maybe every 1/2 hour. I
would
> like to backup to a file. Can a create a backup device (file) on a network
> server so the backup goes directly to another server? Or do I have to
backup
> to the lcoal hard drive and schedule a script to copy it off the drive?
> any info is appreciated. thanks.
>
|||thats what I was thinking. Will I need to log on as the SQLServer Service
account and map the drive? In other words, I was concerned that if I map the
drive under my account it would not exist under the context of the scheduled
task?
"Eric.Li" <anonymous@.microsoftnews.org> wrote in message
news:eB2F$XxUEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> What you can do is map a network drive on your server, then you can
> create a backup device on that mapped drive
> --
> Eric Li
> SQL DBA
> MCDBA
> djc wrote:
would[vbcol=seagreen]
network[vbcol=seagreen]
backup[vbcol=seagreen]
|||thanks for the reply.
can I do this through GUI Enterprise manager? (under database, management,
backup) I am not very familiar with TSQL at this point.
I think I tried to create a new backup device using a UNC name and it would
not let me? (which leads me to believe what your refering to has to be done
using TSQL)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u6BUZaxUEHA.644@.tk2msftngp13.phx.gbl...
> If the service account for the SQL Server service has permissions on the
drive, then yes, you can use a
> network drive. Address it using UNC naming.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
would[vbcol=seagreen]
network[vbcol=seagreen]
backup
>
|||thanks for the reply. Is using TSQL the only way to accomplish this? or
could I use enterprise manager gui. I'm not that familiar with TSQL at this
point.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OfzbFf4UEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Do not perform the FULL database backup every 30 minutes. This will create
> issue once your
> database grow big. I recommend you to do a transaction log backup every 30
> minutes to a remote server and
> perform the FULL database backup once every night.
> Prerequsites to do a backup remotely
> There are Few Pre requisites to do backup remotely;
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
> Now you can execute the Backup script with UNC path
> BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak'
with[vbcol=seagreen]
> init
> Transaction log backup
> --
> BACKUP log <dbname> to disk='\\computername\sharename\dbname_tran1.trn'
> Note:
> Backup to remote machine will not work if you start SQL server using Local
> system account
> Thanks
> Hari
> MCDBA
>
>
> "djc" <noone@.nowhere.com> wrote in message
> news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...
> would
network
> backup
>
|||Yep, you can create the backup device using EM (I just tried it), you just have to type the full UNC name, and
ignore the warning that EM cannot confirm that you have access to the file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:u1np1n5UEHA.1356@.TK2MSFTNGP09.phx.gbl...
> thanks for the reply.
> can I do this through GUI Enterprise manager? (under database, management,
> backup) I am not very familiar with TSQL at this point.
> I think I tried to create a new backup device using a UNC name and it would
> not let me? (which leads me to believe what your refering to has to be done
> using TSQL)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:u6BUZaxUEHA.644@.tk2msftngp13.phx.gbl...
> drive, then yes, you can use a
> news:u4aglSxUEHA.2520@.TK2MSFTNGP12.phx.gbl...
> would
> network
> backup
>
|||I should have added that your problem can very well be permissions problem. Check out the service account for
SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:ef5Wi15UEHA.544@.TK2MSFTNGP11.phx.gbl...
> Yep, you can create the backup device using EM (I just tried it), you just have to type the full UNC name,
and
> ignore the warning that EM cannot confirm that you have access to the file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message news:u1np1n5UEHA.1356@.TK2MSFTNGP09.phx.gbl...
>
|||ok. Great. I had only very quickly given it one attempt before... and I had
an administrative share in the path (\\server\d$ ...etc...) so maybe that
had something to do with it as well. I will also setup the appropriate
permissions for the sql service account... Thanks for the info!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ef5Wi15UEHA.544@.TK2MSFTNGP11.phx.gbl...
> Yep, you can create the backup device using EM (I just tried it), you just
have to type the full UNC name, and
> ignore the warning that EM cannot confirm that you have access to the
file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:u1np1n5UEHA.1356@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
management,[vbcol=seagreen]
would[vbcol=seagreen]
done[vbcol=seagreen]
in[vbcol=seagreen]
the[vbcol=seagreen]
I[vbcol=seagreen]
to[vbcol=seagreen]
drive?
>

Backup Problems - DISK A:

Hy Guys!
I`m having a BIG problem!

This is the way i`m following:

All Tasks - Restore Database - From Device - Select Devices - Add - ...

Error!

Take a look in this popup:

EVENT ID: 26

DESCRIPTION:
Application Popup: sqlserver.exe - No Disk: There is no disk in the drive. Please insert a disk into drive A:

Thanx!You know sometimes Microsoft remembers the last time it opened Explorer, which may have been the 'A' drive, who knows. But have you tried putting a disk into 'A' drive just to get past the error?|||Yes I putted.
But, when i removed it..
The same problm...|||So what steps did you do:[list=1]
Put disk into 'A'
Go into Enterprise Manager and add a backup device
The new backup device you choose was on a drive other than 'A'
Close the Backup/Restore screen
Remove disk from 'A'
[/list=1]
Then go back into Back/Restore?|||I did exactly this. But the same problem.
----------------------
Now,
Take a look in this article:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q301077&

Microsoft tells to install W2K SP3. But it is already installed.

I can`t install the offered patch... It may trouble SP3 instalation...

What do You think?

Should I Install patch ? I need to restore a Database...

PS.: Doing this with T-SQL gives the same message...

This is a servetr that controls almost all bank transactions of BB the principal bak of Brazil.|||I don't want to make the call, but if I had clean backups of my databases, I would apply the patch. However I feel confident that given any situation I would be able to recover.
It is up to you. Not what you wanted to hear.|||heheh!

Not what I wanted to hear.
But, need to be done!

Really appreciate your help!

Thanx!

Backup problems

Hi,
I'm getting "BackupMedium::ReportIoError: write failure on
backup device 'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
Operating system error 112(error not found)" messages in
the SQL 2000 Server logs when we try to backup our
databases. This is followed by "Internal I/O request
0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
Position: 21632512, UMS: Internal: 0x103, InternalHigh:
0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
112, BackupFile: d:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
then "BACKUP failed to complete the command BACKUP
DATABASE [legal] TO DISK = N'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
messages. The database is around 300Mb and we have 40Gb of
free space on the drive.
The server is Dell PE2600 with a Perc Raid controller
handling 3 drives in Raid 5 config. These are split into
two drives; C: for OS and D: for applications and data.
The smaller system databases back up OK as do the
transaction logs. I've found a reference to writeback
cache but don't know if this is the root cause of the
problem. The OS is Windows 2003 Small Business Server with
SQL Server SP3a.
TIA
Trevor>
> Hi,
> I'm getting "BackupMedium::ReportIoError: write failure on
> backup device 'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
> Operating system error 112(error not found)" messages in
> the SQL 2000 Server logs when we try to backup our
> databases. This is followed by "Internal I/O request
> 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> 112, BackupFile: d:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
> then "BACKUP failed to complete the command BACKUP
> DATABASE [legal] TO DISK = N'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
> INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> messages. The database is around 300Mb and we have 40Gb of
> free space on the drive.
> The server is Dell PE2600 with a Perc Raid controller
> handling 3 drives in Raid 5 config. These are split into
> two drives; C: for OS and D: for applications and data.
> The smaller system databases back up OK as do the
> transaction logs. I've found a reference to writeback
> cache but don't know if this is the root cause of the
> problem. The OS is Windows 2003 Small Business Server with
> SQL Server SP3a.
> TIA
> Trevor
>
--
Hi Trevor,
Are you using a compressed volume? It is possible that you are out of
diskspace.
Compressed volumes are not supported. Also checkout the following article:
INF: SQL Server and Striped Backups
http://support.microsoft.com/?id=325334
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional|||Eric Cardenas wrote:
> >
> > Hi,
> > I'm getting "BackupMedium::ReportIoError: write failure on
> > backup device 'd:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
> > Operating system error 112(error not found)" messages in
> > the SQL 2000 Server logs when we try to backup our
> > databases. This is followed by "Internal I/O request
> > 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> > Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> > 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> > 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> > 112, BackupFile: d:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
> > then "BACKUP failed to complete the command BACKUP
> > DATABASE [legal] TO DISK = N'd:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
> > INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> > messages. The database is around 300Mb and we have 40Gb of
> > free space on the drive.
> > The server is Dell PE2600 with a Perc Raid controller
> > handling 3 drives in Raid 5 config. These are split into
> > two drives; C: for OS and D: for applications and data.
> > The smaller system databases back up OK as do the
> > transaction logs. I've found a reference to writeback
> > cache but don't know if this is the root cause of the
> > problem. The OS is Windows 2003 Small Business Server with
> > SQL Server SP3a.
> > TIA
> > Trevor
> >
> --
> Hi Trevor,
> Are you using a compressed volume? It is possible that you are out of
> diskspace.
> Compressed volumes are not supported. Also checkout the following
> article:
> INF: SQL Server and Striped Backups
> http://support.microsoft.com/?id=325334
> Hope this helps,
> --
> Eric Cardenas
> SQL Server senior support professional
Eric,
We should have plenty of disk space. The drives aren't compressed as
far as I am aware.
The databases reside on the same drive that we are backing up to.
We are backing up the databases to a folder on the drive using the SQL
Server backup, and then to tape; the actual database files we exclude
from the tape backup.
The server reports around 40Gb of free space on a 60Gb drive, and the
databases that it fails to back up are our main data database which is
around 200Mb to 250Mb in size, and one of the SQL Server system
databases which looks to be only around 25Mb! The other smaller system
databases back up OK.
The drive is on a Raid 5 array which comprises three 60Gb drives.
We can copy and otherwise create large files on the drive without any
problems; we can copy the database files manually with out any problems
(when we shutdown the SQL Server)
It just seems to be the SQL Server backup of the databases that are
reporting an error.
I've seen some references to writeback cache causing a problem like
this, but nothing that I can say "this is how we fix the problem"
I can't believe that the problem is with the raid striping as I would
then expect loads of people to be reporting this.
Trevor

Backup problems

Hi,
I'm getting "BackupMedium::ReportIoError: write failure on
backup device 'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK'.
Operating system error 112(error not found)" messages in
the SQL 2000 Server logs when we try to backup our
databases. This is followed by "Internal I/O request
0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
Position: 21632512, UMS: Internal: 0x103, InternalHigh:
0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
112, BackupFile: d:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK" and
then "BACKUP failed to complete the command BACKUP
DATABASE [legal] TO DISK = N'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK' WITH
INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
messages. The database is around 300Mb and we have 40Gb of
free space on the drive.
The server is Dell PE2600 with a Perc Raid controller
handling 3 drives in Raid 5 config. These are split into
two drives; C: for OS and D: for applications and data.
The smaller system databases back up OK as do the
transaction logs. I've found a reference to writeback
cache but don't know if this is the root cause of the
problem. The OS is Windows 2003 Small Business Server with
SQL Server SP3a.
TIA
Trevor>
> Hi,
> I'm getting "BackupMedium::ReportIoError: write failure on
> backup device 'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK'.
> Operating system error 112(error not found)" messages in
> the SQL 2000 Server logs when we try to backup our
> databases. This is followed by "Internal I/O request
> 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> 112, BackupFile: d:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK" and
> then "BACKUP failed to complete the command BACKUP
> DATABASE [legal] TO DISK = N'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK' WITH
> INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> messages. The database is around 300Mb and we have 40Gb of
> free space on the drive.
> The server is Dell PE2600 with a Perc Raid controller
> handling 3 drives in Raid 5 config. These are split into
> two drives; C: for OS and D: for applications and data.
> The smaller system databases back up OK as do the
> transaction logs. I've found a reference to writeback
> cache but don't know if this is the root cause of the
> problem. The OS is Windows 2003 Small Business Server with
> SQL Server SP3a.
> TIA
> Trevor
>
--
Hi Trevor,
Are you using a compressed volume? It is possible that you are out of
diskspace.
Compressed volumes are not supported. Also checkout the following article:
INF: SQL Server and Striped Backups
http://support.microsoft.com/?id=325334
Hope this helps,
Eric Crdenas
SQL Server senior support professional|||Eric Cardenas wrote:

> --
> Hi Trevor,
> Are you using a compressed volume? It is possible that you are out of
> diskspace.
> Compressed volumes are not supported. Also checkout the following
> article:
> INF: SQL Server and Striped Backups
> http://support.microsoft.com/?id=325334
> Hope this helps,
> --
> Eric Cardenas
> SQL Server senior support professional
Eric,
We should have plenty of disk space. The drives aren't compressed as
far as I am aware.
The databases reside on the same drive that we are backing up to.
We are backing up the databases to a folder on the drive using the SQL
Server backup, and then to tape; the actual database files we exclude
from the tape backup.
The server reports around 40Gb of free space on a 60Gb drive, and the
databases that it fails to back up are our main data database which is
around 200Mb to 250Mb in size, and one of the SQL Server system
databases which looks to be only around 25Mb! The other smaller system
databases back up OK.
The drive is on a Raid 5 array which comprises three 60Gb drives.
We can copy and otherwise create large files on the drive without any
problems; we can copy the database files manually with out any problems
(when we shutdown the SQL Server)
It just seems to be the SQL Server backup of the databases that are
reporting an error.
I've seen some references to writeback cache causing a problem like
this, but nothing that I can say "this is how we fix the problem"
I can't believe that the problem is with the raid striping as I would
then expect loads of people to be reporting this.
Trevor

Backup problems

Hi,
I'm getting "BackupMedium::ReportIoError: write failure on
backup device 'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK '.
Operating system error 112(error not found)" messages in
the SQL 2000 Server logs when we try to backup our
databases. This is followed by "Internal I/O request
0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
Position: 21632512, UMS: Internal: 0x103, InternalHigh:
0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
112, BackupFile: d:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK " and
then "BACKUP failed to complete the command BACKUP
DATABASE [legal] TO DISK = N'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK ' WITH
INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
messages. The database is around 300Mb and we have 40Gb of
free space on the drive.
The server is Dell PE2600 with a Perc Raid controller
handling 3 drives in Raid 5 config. These are split into
two drives; C: for OS and D: for applications and data.
The smaller system databases back up OK as do the
transaction logs. I've found a reference to writeback
cache but don't know if this is the root cause of the
problem. The OS is Windows 2003 Small Business Server with
SQL Server SP3a.
TIA
Trevor
>
> Hi,
> I'm getting "BackupMedium::ReportIoError: write failure on
> backup device 'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK '.
> Operating system error 112(error not found)" messages in
> the SQL 2000 Server logs when we try to backup our
> databases. This is followed by "Internal I/O request
> 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> 112, BackupFile: d:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK " and
> then "BACKUP failed to complete the command BACKUP
> DATABASE [legal] TO DISK = N'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK ' WITH
> INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> messages. The database is around 300Mb and we have 40Gb of
> free space on the drive.
> The server is Dell PE2600 with a Perc Raid controller
> handling 3 drives in Raid 5 config. These are split into
> two drives; C: for OS and D: for applications and data.
> The smaller system databases back up OK as do the
> transaction logs. I've found a reference to writeback
> cache but don't know if this is the root cause of the
> problem. The OS is Windows 2003 Small Business Server with
> SQL Server SP3a.
> TIA
> Trevor
>
Hi Trevor,
Are you using a compressed volume? It is possible that you are out of
diskspace.
Compressed volumes are not supported. Also checkout the following article:
INF: SQL Server and Striped Backups
http://support.microsoft.com/?id=325334
Hope this helps,
Eric Crdenas
SQL Server senior support professional
|||Eric Cardenas wrote:

> --
> Hi Trevor,
> Are you using a compressed volume? It is possible that you are out of
> diskspace.
> Compressed volumes are not supported. Also checkout the following
> article:
> INF: SQL Server and Striped Backups
> http://support.microsoft.com/?id=325334
> Hope this helps,
> --
> Eric Cardenas
> SQL Server senior support professional
Eric,
We should have plenty of disk space. The drives aren't compressed as
far as I am aware.
The databases reside on the same drive that we are backing up to.
We are backing up the databases to a folder on the drive using the SQL
Server backup, and then to tape; the actual database files we exclude
from the tape backup.
The server reports around 40Gb of free space on a 60Gb drive, and the
databases that it fails to back up are our main data database which is
around 200Mb to 250Mb in size, and one of the SQL Server system
databases which looks to be only around 25Mb! The other smaller system
databases back up OK.
The drive is on a Raid 5 array which comprises three 60Gb drives.
We can copy and otherwise create large files on the drive without any
problems; we can copy the database files manually with out any problems
(when we shutdown the SQL Server)
It just seems to be the SQL Server backup of the databases that are
reporting an error.
I've seen some references to writeback cache causing a problem like
this, but nothing that I can say "this is how we fix the problem"
I can't believe that the problem is with the raid striping as I would
then expect loads of people to be reporting this.
Trevor

Backup or Restore from Enterprise Manager.

We've added a new disk to our server.
When we click through the SQL Server Backup, to select
the "Backup Device Location", the new drive is not
available. The only drive that is available is the one
that existed when SQL was installed.
The same is true for restores.
Any ideas?
TIA,
Sean.
Hi,
Execute the below command from Query Analyzer;
xp_fixeddrives
If you are not able to see the new drive, Check for the existence of that
drive from Windows Explorer, if not contact your system administrator.
Thanks
Hari
MCDBA
"Sean Irving" <sbirving@.hotmail.com> wrote in message
news:178ae01c41dfe$8f99da60$a601280a@.phx.gbl...
> We've added a new disk to our server.
> When we click through the SQL Server Backup, to select
> the "Backup Device Location", the new drive is not
> available. The only drive that is available is the one
> that existed when SQL was installed.
> The same is true for restores.
> Any ideas?
> TIA,
> Sean.
>
|||If SQL Server is clustered, you have to add a dependency (SQL Server has to
depend on the disk). Also make sure you've restarted Enterprise Manager
since the disk was added, it may not have refreshed with the new
information.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Backup on remote disk

hi gurus,

can any bdy tell me the procedure to create the Backup Device which is a DISK OF REMOTE PC..

i want to take database backup on remote pc's disk not on local disk or tape

i am using sql server 2005

thanks

in advance

I believe you want to backup your db to a remote pcs hard disk.....just perform the following,

1.ensure you run the the sql server using service account instead of local system account

2.ensure that your sql service account has modify privileges in the remote pcs shared folder......

http://msdn2.microsoft.com/en-us/library/ms179313.aspx

refer this command

USE master;
GO
EXEC sp_addumpdevice 'disk', 'networkdevice',
'\\<servername>\<sharename>\<path>\<filename>.bak'

http://msdn2.microsoft.com/en-us/library/ms188409.aspx fyi

just check if those links are useful......

thanks

|||

actually, you do not need to add a dump device, simply execute:

Code Snippet

backup database MyDB to disk = '\\Server\Share\BackupFilename.BAK'

Backup Jobs

I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
created a backup device first and then the backup job. For 1 of them I just
created the backup job. I would like to delete the job that has no backup
device and would also like to edit the other 3 jobs. I do not see how to do
this. I can see my backup devices but not the jobs themself.
Can someone tell me how I can delete the one job and edit the remaining 3?
Thanks
JohnnyDid you check SQL Server Agent - Jobs ?
"Johnny Wright" wrote:

> I have created 4 backup jobs inside of Enterprise Manager. For 3 of them
I
> created a backup device first and then the backup job. For 1 of them I ju
st
> created the backup job. I would like to delete the job that has no backup
> device and would also like to edit the other 3 jobs. I do not see how to
do
> this. I can see my backup devices but not the jobs themself.
> Can someone tell me how I can delete the one job and edit the remaining 3?
> Thanks
> Johnny|||Umut
No I did not. Thanks for the quick response.
Ahhh such a simple thing when you know how..
Johnny
"Umut Nazlica" wrote:
[vbcol=seagreen]
> Did you check SQL Server Agent - Jobs ?
>
> "Johnny Wright" wrote:
>

Backup Jobs

I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
created a backup device first and then the backup job. For 1 of them I just
created the backup job. I would like to delete the job that has no backup
device and would also like to edit the other 3 jobs. I do not see how to do
this. I can see my backup devices but not the jobs themself.
Can someone tell me how I can delete the one job and edit the remaining 3?
Thanks
Johnny
Did you check SQL Server Agent - Jobs ?
"Johnny Wright" wrote:

> I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
> created a backup device first and then the backup job. For 1 of them I just
> created the backup job. I would like to delete the job that has no backup
> device and would also like to edit the other 3 jobs. I do not see how to do
> this. I can see my backup devices but not the jobs themself.
> Can someone tell me how I can delete the one job and edit the remaining 3?
> Thanks
> Johnny
|||Umut
No I did not. Thanks for the quick response.
Ahhh such a simple thing when you know how..
Johnny
"Umut Nazlica" wrote:
[vbcol=seagreen]
> Did you check SQL Server Agent - Jobs ?
>
> "Johnny Wright" wrote:

Backup Jobs

I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
created a backup device first and then the backup job. For 1 of them I just
created the backup job. I would like to delete the job that has no backup
device and would also like to edit the other 3 jobs. I do not see how to do
this. I can see my backup devices but not the jobs themself.
Can someone tell me how I can delete the one job and edit the remaining 3?
Thanks
JohnnyDid you check SQL Server Agent - Jobs ?
"Johnny Wright" wrote:
> I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
> created a backup device first and then the backup job. For 1 of them I just
> created the backup job. I would like to delete the job that has no backup
> device and would also like to edit the other 3 jobs. I do not see how to do
> this. I can see my backup devices but not the jobs themself.
> Can someone tell me how I can delete the one job and edit the remaining 3?
> Thanks
> Johnny|||Umut
No I did not. Thanks for the quick response.
Ahhh such a simple thing when you know how..
Johnny
"Umut Nazlica" wrote:
> Did you check SQL Server Agent - Jobs ?
>
> "Johnny Wright" wrote:
> > I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
> > created a backup device first and then the backup job. For 1 of them I just
> > created the backup job. I would like to delete the job that has no backup
> > device and would also like to edit the other 3 jobs. I do not see how to do
> > this. I can see my backup devices but not the jobs themself.
> >
> > Can someone tell me how I can delete the one job and edit the remaining 3?
> > Thanks
> > Johnny