Sql Backing up Tables: std

Showing posts with label std. Show all posts

Thursday, March 8, 2012

backup big db fail

I everybody,
I have a big (well, this is relative) db, when I do a full db backup, the
.bak is arount 190G
I run under windows std server 2000, 2G mem, 4 cpu,sql server 2000
enterprise ed.
I backup the database to a dedicated server via UNC name with a dedicated
network card. I have not enought space on local disk
I do a backup every day but perhaps 1 backup per week works.
I get the following error message :
Error 1450 is : Insufficient system resources exist to complete the
requested service.
what "ressource" is not enough ? this is not the disk space since the
target server (windows 2003 R2) has 3T free space.
hope some one has some advise.
thanks in advance
BackupMedium::ReportIoError :
chec write sur l'unit de sauvegarde _\\storage\backup\Backup_22\SD_db_
200707291858.BAK_.
Erreur du systme d'exploitation 1450
(Ressources systme insuffisantes pour terminer le service demand.).
La sauvegarde n'a pas russir achever la commande
BACKUP DATABASE [SIMD] TO DISK = N'\\storage\backup\Backup_22\SD_db_
200707291858.BAK'
WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
Internal I/O request 0x05702918:
Op: Write, pBuffer: 0x05710000, Size: 983040,
Position: 137109051904, RetryCount: 10, UMS: Internal: 0x0,
InternalHigh: 0xF0000, Offset: 0xEC561A00, OffsetHigh: 0x1F, m_buf:
0x05710000,
m_len: 983040, m_actualBytes: 0, m_errcode: 1450,
BackupFile: \\storage\backup\Backup_22\SD_db_2007072
91858.BAKIt's probably talking about memory on the server that SQL Server is running
on. Why would you possibly have the need for Enterprise Edition and 4
processors with 190GB of data but only have 2GB of memory. My laptop has
more than that. Are you using any of the 3rd part backup & compression
tools or is this a native SQL backup? If not I would highly recommend
buying one of them and adding more memory.
Andrew J. Kelly SQL MVP
"906507N" <906507N@.10090.I20034> wrote in message
news:Xns998147FE8B8D0140507NA02619@.207.46.248.16...
>I everybody,
> I have a big (well, this is relative) db, when I do a full db backup, the
> .bak is arount 190G
> I run under windows std server 2000, 2G mem, 4 cpu,sql server 2000
> enterprise ed.
> I backup the database to a dedicated server via UNC name with a dedicated
> network card. I have not enought space on local disk
> I do a backup every day but perhaps 1 backup per week works.
> I get the following error message :
> Error 1450 is : Insufficient system resources exist to complete the
> requested service.
> what "ressource" is not enough ? this is not the disk space since the
> target server (windows 2003 R2) has 3T free space.
> hope some one has some advise.
> thanks in advance
> BackupMedium::ReportIoError :
> chec write sur l'unit de sauvegarde \\storage\backup\Backup_22\SD_db_
> 200707291858.BAK .
> Erreur du systme d'exploitation 1450
> (Ressources systme insuffisantes pour terminer le service demand.).
> La sauvegarde n'a pas russir achever la commande
> BACKUP DATABASE [SIMD] TO DISK = N'\\storage\backup\Backup_22\SD_db_
> 200707291858.BAK'
> WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> Internal I/O request 0x05702918:
> Op: Write, pBuffer: 0x05710000, Size: 983040,
> Position: 137109051904, RetryCount: 10, UMS: Internal: 0x0,
> InternalHigh: 0xF0000, Offset: 0xEC561A00, OffsetHigh: 0x1F, m_buf:
> 0x05710000,
> m_len: 983040, m_actualBytes: 0, m_errcode: 1450,
> BackupFile: \\storage\backup\Backup_22\SD_db_2007072
91858.BAK|||On Aug 2, 6:55 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> It's probably talking about memory on the server that SQL Server is runni=
ng
> on. Why would you possibly have the need for Enterprise Edition and 4
> processors with 190GB of data but only have 2GB of memory. My laptop has
> more than that. Are you using any of the 3rd part backup & compression
> tools or is this a native SQL backup? If not I would highly recommend
> buying one of them and adding more memory.
> --
> Andrew J. Kelly SQL MVP
> "906507N" <9065...@.10090.I20034> wrote in message
> news:Xns998147FE8B8D0140507NA02619@.207.46.248.16...
>
>
>
he[vbcol=seagreen]
>
ed[vbcol=seagreen]
>
>
>
>
>
2\SD_db_[vbcol=seagreen]
)=2E[vbcol=seagreen]
ted text -[vbcol=seagreen]
> - Show quoted text -
That is a rather low amount of memory for a box with those
specifications and needs. I'm not sure if this problem is memory
related, but I've also read a lot of various posts in regards to
posting large files to a network location. Again, most of these will
give other errors than the ones you reported, but might be another
avenue to venture through.|||Try it out first with a local storage - probably a USB drive that can
accommodate 190GB and dump your backup there and see what happens
"acorcoran" <acorcoran@.gmail.com> wrote in message
news:1186105163.744059.159720@.i38g2000prf.googlegroups.com...
On Aug 2, 6:55 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> It's probably talking about memory on the server that SQL Server is
> running
> on. Why would you possibly have the need for Enterprise Edition and 4
> processors with 190GB of data but only have 2GB of memory. My laptop has
> more than that. Are you using any of the 3rd part backup & compression
> tools or is this a native SQL backup? If not I would highly recommend
> buying one of them and adding more memory.
> --
> Andrew J. Kelly SQL MVP
> "906507N" <9065...@.10090.I20034> wrote in message
> news:Xns998147FE8B8D0140507NA02619@.207.46.248.16...
>
>
>
>
>
>
>
>
>
> - Show quoted text -
That is a rather low amount of memory for a box with those
specifications and needs. I'm not sure if this problem is memory
related, but I've also read a lot of various posts in regards to
posting large files to a network location. Again, most of these will
give other errors than the ones you reported, but might be another
avenue to venture through.|||How's the space on your C: drive or wherever the OS pagefile is?
J.
On Thu, 02 Aug 2007 15:26:31 -0700, 906507N <906507N@.10090.I20034>
wrote:

>I everybody,
>I have a big (well, this is relative) db, when I do a full db backup, the
>.bak is arount 190G
>I run under windows std server 2000, 2G mem, 4 cpu,sql server 2000
>enterprise ed.
>I backup the database to a dedicated server via UNC name with a dedicated
>network card. I have not enought space on local disk
>I do a backup every day but perhaps 1 backup per week works.
>I get the following error message :
>Error 1450 is : Insufficient system resources exist to complete the
>requested service.
>what "ressource" is not enough ? this is not the disk space since the
>target server (windows 2003 R2) has 3T free space.
>hope some one has some advise.
>thanks in advance
>BackupMedium::ReportIoError :
>chec write sur l'unit de sauvegarde _\\storage\backup\Backup_22\SD_db_
>200707291858.BAK_.
>Erreur du systme d'exploitation 1450
>(Ressources systme insuffisantes pour terminer le service demand.).
>La sauvegarde n'a pas russir achever la commande
>BACKUP DATABASE [SIMD] TO DISK = N'\\storage\backup\Backup_22\SD_db_
>200707291858.BAK'
>WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
>Internal I/O request 0x05702918:
>Op: Write, pBuffer: 0x05710000, Size: 983040,
>Position: 137109051904, RetryCount: 10, UMS: Internal: 0x0,
>InternalHigh: 0xF0000, Offset: 0xEC561A00, OffsetHigh: 0x1F, m_buf:
>0x05710000,
>m_len: 983040, m_actualBytes: 0, m_errcode: 1450,
>BackupFile: \\storage\backup\Backup_22\SD_db_2007072
91858.BAK

backup big db fail

I everybody,
I have a big (well, this is relative) db, when I do a full db backup, the
.bak is arount 190G
I run under windows std server 2000, 2G mem, 4 cpu,sql server 2000
enterprise ed.
I backup the database to a dedicated server via UNC name with a dedicated
network card. I have not enought space on local disk
I do a backup every day but perhaps 1 backup per week works.
I get the following error message :
Error 1450 is : Insufficient system resources exist to complete the
requested service.
what "ressource" is not enough ? this is not the disk space since the
target server (windows 2003 R2) has 3T free space.
hope some one has some advise.
thanks in advance
BackupMedium::ReportIoError :
échec write sur l'unité de sauvegarde « \\storage\backup\Backup_22\SD_db_
200707291858.BAK ».
Erreur du système d'exploitation 1450
(Ressources système insuffisantes pour terminer le service demandé.).
La sauvegarde n'a pas réussir à achever la commande
BACKUP DATABASE [SIMD] TO DISK = N'\\storage\backup\Backup_22\SD_db_
200707291858.BAK'
WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
Internal I/O request 0x05702918:
Op: Write, pBuffer: 0x05710000, Size: 983040,
Position: 137109051904, RetryCount: 10, UMS: Internal: 0x0,
InternalHigh: 0xF0000, Offset: 0xEC561A00, OffsetHigh: 0x1F, m_buf:
0x05710000,
m_len: 983040, m_actualBytes: 0, m_errcode: 1450,
BackupFile: \\storage\backup\Backup_22\SD_db_200707291858.BAKIt's probably talking about memory on the server that SQL Server is running
on. Why would you possibly have the need for Enterprise Edition and 4
processors with 190GB of data but only have 2GB of memory. My laptop has
more than that. Are you using any of the 3rd part backup & compression
tools or is this a native SQL backup? If not I would highly recommend
buying one of them and adding more memory.
--
Andrew J. Kelly SQL MVP
"906507N" <906507N@.10090.I20034> wrote in message
news:Xns998147FE8B8D0140507NA02619@.207.46.248.16...
>I everybody,
> I have a big (well, this is relative) db, when I do a full db backup, the
> .bak is arount 190G
> I run under windows std server 2000, 2G mem, 4 cpu,sql server 2000
> enterprise ed.
> I backup the database to a dedicated server via UNC name with a dedicated
> network card. I have not enought space on local disk
> I do a backup every day but perhaps 1 backup per week works.
> I get the following error message :
> Error 1450 is : Insufficient system resources exist to complete the
> requested service.
> what "ressource" is not enough ? this is not the disk space since the
> target server (windows 2003 R2) has 3T free space.
> hope some one has some advise.
> thanks in advance
> BackupMedium::ReportIoError :
> échec write sur l'unité de sauvegarde « \\storage\backup\Backup_22\SD_db_
> 200707291858.BAK ».
> Erreur du système d'exploitation 1450
> (Ressources système insuffisantes pour terminer le service demandé.).
> La sauvegarde n'a pas réussir à achever la commande
> BACKUP DATABASE [SIMD] TO DISK = N'\\storage\backup\Backup_22\SD_db_
> 200707291858.BAK'
> WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> Internal I/O request 0x05702918:
> Op: Write, pBuffer: 0x05710000, Size: 983040,
> Position: 137109051904, RetryCount: 10, UMS: Internal: 0x0,
> InternalHigh: 0xF0000, Offset: 0xEC561A00, OffsetHigh: 0x1F, m_buf:
> 0x05710000,
> m_len: 983040, m_actualBytes: 0, m_errcode: 1450,
> BackupFile: \\storage\backup\Backup_22\SD_db_200707291858.BAK|||On Aug 2, 6:55 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> It's probably talking about memory on the server that SQL Server is runni=ng
> on. Why would you possibly have the need for Enterprise Edition and 4
> processors with 190GB of data but only have 2GB of memory. My laptop has
> more than that. Are you using any of the 3rd part backup & compression
> tools or is this a native SQL backup? If not I would highly recommend
> buying one of them and adding more memory.
> --
> Andrew J. Kelly SQL MVP
> "906507N" <9065...@.10090.I20034> wrote in message
> news:Xns998147FE8B8D0140507NA02619@.207.46.248.16...
>
> >I everybody,
> > I have a big (well, this is relative) db, when I do a full db backup, t=he
> > .bak is arount 190G
> > I run under windows std server 2000, 2G mem, 4 cpu,sql server 2000
> > enterprise ed.
> > I backup the database to a dedicated server via UNC name with a dedicat=ed
> > network card. I have not enought space on local disk
> > I do a backup every day but perhaps 1 backup per week works.
> > I get the following error message :
> > Error 1450 is : Insufficient system resources exist to complete the
> > requested service.
> > what "ressource" is not enough ? this is not the disk space since the
> > target server (windows 2003 R2) has 3T free space.
> > hope some one has some advise.
> > thanks in advance
> > BackupMedium::ReportIoError :
> > =E9chec write sur l'unit=E9 de sauvegarde =AB \\storage\backup\Backup_2=2\SD_db_
> > 200707291858.BAK =BB.
> > Erreur du syst=E8me d'exploitation 1450
> > (Ressources syst=E8me insuffisantes pour terminer le service demand=E9.=)=2E
> > La sauvegarde n'a pas r=E9ussir =E0 achever la commande
> > BACKUP DATABASE [SIMD] TO DISK =3D N'\\storage\backup\Backup_22\SD_db_
> > 200707291858.BAK'
> > WITH INIT , NOUNLOAD , NOSKIP , STATS =3D 10, NOFORMAT
> > Internal I/O request 0x05702918:
> > Op: Write, pBuffer: 0x05710000, Size: 983040,
> > Position: 137109051904, RetryCount: 10, UMS: Internal: 0x0,
> > InternalHigh: 0xF0000, Offset: 0xEC561A00, OffsetHigh: 0x1F, m_buf:
> > 0x05710000,
> > m_len: 983040, m_actualBytes: 0, m_errcode: 1450,
> > BackupFile: \\storage\backup\Backup_22\SD_db_200707291858.BAK- Hide quo=ted text -
> - Show quoted text -
That is a rather low amount of memory for a box with those
specifications and needs. I'm not sure if this problem is memory
related, but I've also read a lot of various posts in regards to
posting large files to a network location. Again, most of these will
give other errors than the ones you reported, but might be another
avenue to venture through.|||Try it out first with a local storage - probably a USB drive that can
accommodate 190GB and dump your backup there and see what happens
"acorcoran" <acorcoran@.gmail.com> wrote in message
news:1186105163.744059.159720@.i38g2000prf.googlegroups.com...
On Aug 2, 6:55 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> It's probably talking about memory on the server that SQL Server is
> running
> on. Why would you possibly have the need for Enterprise Edition and 4
> processors with 190GB of data but only have 2GB of memory. My laptop has
> more than that. Are you using any of the 3rd part backup & compression
> tools or is this a native SQL backup? If not I would highly recommend
> buying one of them and adding more memory.
> --
> Andrew J. Kelly SQL MVP
> "906507N" <9065...@.10090.I20034> wrote in message
> news:Xns998147FE8B8D0140507NA02619@.207.46.248.16...
>
> >I everybody,
> > I have a big (well, this is relative) db, when I do a full db backup,
> > the
> > .bak is arount 190G
> > I run under windows std server 2000, 2G mem, 4 cpu,sql server 2000
> > enterprise ed.
> > I backup the database to a dedicated server via UNC name with a
> > dedicated
> > network card. I have not enought space on local disk
> > I do a backup every day but perhaps 1 backup per week works.
> > I get the following error message :
> > Error 1450 is : Insufficient system resources exist to complete the
> > requested service.
> > what "ressource" is not enough ? this is not the disk space since the
> > target server (windows 2003 R2) has 3T free space.
> > hope some one has some advise.
> > thanks in advance
> > BackupMedium::ReportIoError :
> > échec write sur l'unité de sauvegarde «
> > \\storage\backup\Backup_22\SD_db_
> > 200707291858.BAK ».
> > Erreur du système d'exploitation 1450
> > (Ressources système insuffisantes pour terminer le service demandé.).
> > La sauvegarde n'a pas réussir à achever la commande
> > BACKUP DATABASE [SIMD] TO DISK = N'\\storage\backup\Backup_22\SD_db_
> > 200707291858.BAK'
> > WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> > Internal I/O request 0x05702918:
> > Op: Write, pBuffer: 0x05710000, Size: 983040,
> > Position: 137109051904, RetryCount: 10, UMS: Internal: 0x0,
> > InternalHigh: 0xF0000, Offset: 0xEC561A00, OffsetHigh: 0x1F, m_buf:
> > 0x05710000,
> > m_len: 983040, m_actualBytes: 0, m_errcode: 1450,
> > BackupFile: \\storage\backup\Backup_22\SD_db_200707291858.BAK- Hide
> > quoted text -
> - Show quoted text -
That is a rather low amount of memory for a box with those
specifications and needs. I'm not sure if this problem is memory
related, but I've also read a lot of various posts in regards to
posting large files to a network location. Again, most of these will
give other errors than the ones you reported, but might be another
avenue to venture through.|||How's the space on your C: drive or wherever the OS pagefile is?
J.
On Thu, 02 Aug 2007 15:26:31 -0700, 906507N <906507N@.10090.I20034>
wrote:
>I everybody,
>I have a big (well, this is relative) db, when I do a full db backup, the
>.bak is arount 190G
>I run under windows std server 2000, 2G mem, 4 cpu,sql server 2000
>enterprise ed.
>I backup the database to a dedicated server via UNC name with a dedicated
>network card. I have not enought space on local disk
>I do a backup every day but perhaps 1 backup per week works.
>I get the following error message :
>Error 1450 is : Insufficient system resources exist to complete the
>requested service.
>what "ressource" is not enough ? this is not the disk space since the
>target server (windows 2003 R2) has 3T free space.
>hope some one has some advise.
>thanks in advance
>BackupMedium::ReportIoError :
>échec write sur l'unité de sauvegarde « \\storage\backup\Backup_22\SD_db_
>200707291858.BAK ».
>Erreur du système d'exploitation 1450
>(Ressources système insuffisantes pour terminer le service demandé.).
>La sauvegarde n'a pas réussir à achever la commande
>BACKUP DATABASE [SIMD] TO DISK = N'\\storage\backup\Backup_22\SD_db_
>200707291858.BAK'
>WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
>Internal I/O request 0x05702918:
>Op: Write, pBuffer: 0x05710000, Size: 983040,
>Position: 137109051904, RetryCount: 10, UMS: Internal: 0x0,
>InternalHigh: 0xF0000, Offset: 0xEC561A00, OffsetHigh: 0x1F, m_buf:
>0x05710000,
>m_len: 983040, m_actualBytes: 0, m_errcode: 1450,
>BackupFile: \\storage\backup\Backup_22\SD_db_200707291858.BAK

Friday, February 24, 2012

backup again

Dear All,
does sql2005(std.) have any tools for backup whole database to file for
other Backup software backup?
thx,
WilliamWilliam
Can you elaborate a little bit? What are yopu trying to achive?
"William Cheung" <chun_hei@.msn.com> wrote in message
news:Ox1xeyjAHHA.3396@.TK2MSFTNGP02.phx.gbl...
> Dear All,
> does sql2005(std.) have any tools for backup whole database to file for
> other Backup software backup?
> thx,
> William
>|||Dear,
i want to backup the SQL Server while without advance backup software(CA,
symantec...).
reg,
William
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23x8xo3jAHHA.204@.TK2MSFTNGP04.phx.gbl...
> William
> Can you elaborate a little bit? What are yopu trying to achive?
> "William Cheung" <chun_hei@.msn.com> wrote in message
> news:Ox1xeyjAHHA.3396@.TK2MSFTNGP02.phx.gbl...
>> Dear All,
>> does sql2005(std.) have any tools for backup whole database to file for
>> other Backup software backup?
>> thx,
>> William
>|||Hi
See ,BACKUP DATABASE command in the BOL
"William Cheung" <chun_hei@.msn.com> wrote in message
news:uC8T4DkAHHA.3380@.TK2MSFTNGP04.phx.gbl...
> Dear,
> i want to backup the SQL Server while without advance backup software(CA,
> symantec...).
> reg,
> William
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23x8xo3jAHHA.204@.TK2MSFTNGP04.phx.gbl...
>> William
>> Can you elaborate a little bit? What are yopu trying to achive?
>> "William Cheung" <chun_hei@.msn.com> wrote in message
>> news:Ox1xeyjAHHA.3396@.TK2MSFTNGP02.phx.gbl...
>> Dear All,
>> does sql2005(std.) have any tools for backup whole database to file for
>> other Backup software backup?
>> thx,
>> William
>>
>|||With SQL 2005 Standard Edition, you can create a "Maintenance Job" to backup
on schedule, or you can create a SQL Agent Job to execute a SQL Backup
command.
SQL Backup is quite robust, and you may be OK without any other software.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:Ox1xeyjAHHA.3396@.TK2MSFTNGP02.phx.gbl...
> Dear All,
> does sql2005(std.) have any tools for backup whole database to file for
> other Backup software backup?
> thx,
> William
>|||Hi,
can i be schedule run? how to restore? can you pls send me some reference
for futher study.
thx,
William
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23SGqKKkAHHA.4808@.TK2MSFTNGP03.phx.gbl...
> Hi
>
> See ,BACKUP DATABASE command in the BOL
>
>
> "William Cheung" <chun_hei@.msn.com> wrote in message
> news:uC8T4DkAHHA.3380@.TK2MSFTNGP04.phx.gbl...
>> Dear,
>> i want to backup the SQL Server while without advance backup software(CA,
>> symantec...).
>> reg,
>> William
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23x8xo3jAHHA.204@.TK2MSFTNGP04.phx.gbl...
>> William
>> Can you elaborate a little bit? What are yopu trying to achive?
>> "William Cheung" <chun_hei@.msn.com> wrote in message
>> news:Ox1xeyjAHHA.3396@.TK2MSFTNGP02.phx.gbl...
>> Dear All,
>> does sql2005(std.) have any tools for backup whole database to file for
>> other Backup software backup?
>> thx,
>> William
>>
>>
>|||Hi
> can i be schedule run?
Sure, create a job with BACKUP DATABASE... command and schedule it
? how to restore?
Take a look at RESTORE DATABASE ...command in the BOL
?can you pls send me some reference
> for futher study.
Start with BOL (Books On Line ) which ships with SQL Server
"William Cheung" <chun_hei@.msn.com> wrote in message
news:OEfjMPkAHHA.2316@.TK2MSFTNGP04.phx.gbl...
> Hi,
> can i be schedule run? how to restore? can you pls send me some reference
> for futher study.
> thx,
> William
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23SGqKKkAHHA.4808@.TK2MSFTNGP03.phx.gbl...
>> Hi
>>
>> See ,BACKUP DATABASE command in the BOL
>>
>>
>> "William Cheung" <chun_hei@.msn.com> wrote in message
>> news:uC8T4DkAHHA.3380@.TK2MSFTNGP04.phx.gbl...
>> Dear,
>> i want to backup the SQL Server while without advance backup
>> software(CA, symantec...).
>> reg,
>> William
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23x8xo3jAHHA.204@.TK2MSFTNGP04.phx.gbl...
>> William
>> Can you elaborate a little bit? What are yopu trying to achive?
>> "William Cheung" <chun_hei@.msn.com> wrote in message
>> news:Ox1xeyjAHHA.3396@.TK2MSFTNGP02.phx.gbl...
>> Dear All,
>> does sql2005(std.) have any tools for backup whole database to file
>> for other Backup software backup?
>> thx,
>> William
>>
>>
>>
>|||Hi
you have to create backup script first and schedule it through sql job.
Schedule depends on your requirements and how much data you can afford to
lose
Here is the very basic script
full backup
BACKUP DATABASE [myDB] TO DISK=N'c:\myDBbackup.bak' WITH
NOINIT,Name='myDBbackup'
differential
BACKUP DATABASE [myDB] TO DISK=N'c:\myDBbackup.bak' WITH
NOINIT,DIFFERENTIAL,Name='myDBbackup'
log
BACKUP LOG [myDB] TO DISK = N'c:\myDBbackup.bak' WITH NOINIT , NOUNLOAD ,
NAME = 'myDBbackup', NOSKIP , STATS = 10, NOFORMAT
You need to understand how restore works... BOL is the best tool..
You will get some custom script from the following site
www.sqlservercentral.com
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx
http://www.databasejournal.com/features/mssql/article.php/3389831
vinu
"William Cheung" <chun_hei@.msn.com> wrote in message
news:OEfjMPkAHHA.2316@.TK2MSFTNGP04.phx.gbl...
> Hi,
> can i be schedule run? how to restore? can you pls send me some reference
> for futher study.
> thx,
> William
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23SGqKKkAHHA.4808@.TK2MSFTNGP03.phx.gbl...
>> Hi
>>
>> See ,BACKUP DATABASE command in the BOL
>>
>>
>> "William Cheung" <chun_hei@.msn.com> wrote in message
>> news:uC8T4DkAHHA.3380@.TK2MSFTNGP04.phx.gbl...
>> Dear,
>> i want to backup the SQL Server while without advance backup
>> software(CA, symantec...).
>> reg,
>> William
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23x8xo3jAHHA.204@.TK2MSFTNGP04.phx.gbl...
>> William
>> Can you elaborate a little bit? What are yopu trying to achive?
>> "William Cheung" <chun_hei@.msn.com> wrote in message
>> news:Ox1xeyjAHHA.3396@.TK2MSFTNGP02.phx.gbl...
>> Dear All,
>> does sql2005(std.) have any tools for backup whole database to file
>> for other Backup software backup?
>> thx,
>> William
>>
>>
>>
>|||William,
You don't need to purchase the third party open file, SQL
agents to do SQL Server backups. They aren't used that often
and are often problematic - it's more common to just use
SQL Server native backups and backup to disk. Enterprise
backup software or tape backups can then just backup the SQL
Server backup file that you create with the SQL Server
native backup. As others have pointed out, you just use
T-SQL backup commands, you can schedule these using SQL
Server Agent.
-Sue
On Tue, 7 Nov 2006 15:16:17 +0800, "William Cheung"
<chun_hei@.msn.com> wrote:
>Dear All,
>does sql2005(std.) have any tools for backup whole database to file for
>other Backup software backup?
>thx,
>William
>

Thursday, March 8, 2012

backup big db fail

backup big db fail

Friday, February 24, 2012

backup again

backup again

backup again

backup again

Sql Backing up Tables

Blog Archive

About Me