Backup Error

I saw the following logged in the event log:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 9/14/2005
Time: 12:20:00 AM
User: N/A
Computer: BRADFORDDC01
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'Master Maintenance Plan'' (0x6FF812A8ED86514CBDF51CE01D6147ED) - Status:
Failed - Invoked on: 2005-09-14 00:20:00 - Message: The job failed. The Job
was invoked by Schedule 9 (Schedule 1). The last step to run was step 1
(Step 1).
The error appears to occur when backing up the transaction log of the
"master" database. I have verified that all of the databases are set to a
recovery mode of "Full," and also added the "-SupportComputedColumn" flag to
the job (as per MS KB). I created a new maintenance plan for the master DB
to isolate the
failing job, and I am still receiving this error, can anyone offer any
insight?
Thanks,
RobRobert,
The transaction log of the Master database cannot be backed up. Use a full
database backup for the Master system database.
HTH
Jerry
"Robert Zahm" <robzahm@.hotmail.com> wrote in message
news:eBgoxEVuFHA.1032@.TK2MSFTNGP12.phx.gbl...
>I saw the following logged in the event log:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 9/14/2005
> Time: 12:20:00 AM
> User: N/A
> Computer: BRADFORDDC01
> Description:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
> Plan 'Master Maintenance Plan'' (0x6FF812A8ED86514CBDF51CE01D6147ED) -
> Status: Failed - Invoked on: 2005-09-14 00:20:00 - Message: The job
> failed. The Job was invoked by Schedule 9 (Schedule 1). The last step to
> run was step 1 (Step 1).
>
> The error appears to occur when backing up the transaction log of the
> "master" database. I have verified that all of the databases are set to a
> recovery mode of "Full," and also added the "-SupportComputedColumn" flag
> to
> the job (as per MS KB). I created a new maintenance plan for the master
> DB to isolate the
> failing job, and I am still receiving this error, can anyone offer any
> insight?
> Thanks,
> Rob
>
>|||Hi,
You can not backup the trsnaction log backup of Master database. Since you
are not doing any transaction inside Master it is not required
to do a log backup in Master database. It is always if you do a Full
database backup for MASTER database daily once.
It is not good practice to crete tables/ objects in Master database.
Thanks
Hari
SQL Server MVP
"Robert Zahm" <robzahm@.hotmail.com> wrote in message
news:eBgoxEVuFHA.1032@.TK2MSFTNGP12.phx.gbl...
>I saw the following logged in the event log:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 9/14/2005
> Time: 12:20:00 AM
> User: N/A
> Computer: BRADFORDDC01
> Description:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
> Plan 'Master Maintenance Plan'' (0x6FF812A8ED86514CBDF51CE01D6147ED) -
> Status: Failed - Invoked on: 2005-09-14 00:20:00 - Message: The job
> failed. The Job was invoked by Schedule 9 (Schedule 1). The last step to
> run was step 1 (Step 1).
>
> The error appears to occur when backing up the transaction log of the
> "master" database. I have verified that all of the databases are set to a
> recovery mode of "Full," and also added the "-SupportComputedColumn" flag
> to
> the job (as per MS KB). I created a new maintenance plan for the master
> DB to isolate the
> failing job, and I am still receiving this error, can anyone offer any
> insight?
> Thanks,
> Rob
>
>

Backup and zip the Transaction log file

Once the procedure is executed the database transaction log would be backed up and zipped with a blank text file which has the
the current date DD/MM/yyyy as the text file name

exec ('exec master..xp_cmdshell ''dtsrun /SItchy /Usa /PF!gl@.59b#fl@.#f!uxr /N'+@.defaultCSVFeed_DTS+''' ')
exec ('exec master..xp_cmdshell ''E:\Inetpub\wwwroot\BIASS\wzzip.exe E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.zip E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.'+@.defaultCSVFeed_FileType+''' ')

Pls let me know how can i zip the backup file with a blank text file with the date as the file name of the blank text file...hey... its URGENT.... pls can anybody help me on this...... :(

Backup and zip the Transaction log file

Once the procedure is executed the database transaction log would be backed up and zipped with a blank text file which has the
the current date DD/MM/yyyy as the text file name

exec ('exec master..xp_cmdshell ''dtsrun /SItchy /Usa /PF!gl@.59b#fl@.#f!uxr /N'+@.defaultCSVFeed_DTS+''' ')
exec ('exec master..xp_cmdshell ''E:\Inetpub\wwwroot\BIASS\wzzip.exe E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.zip E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.'+@.defaultCSVFeed_FileType+''' ')

Pls let me know how can i zip the backup file with a blank text file with the date as the file name of the blank text file...As you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR.

Backup and restore scripts

Any one have implemented backup, recovery stored procedures which
takes the uments for dbname, date, time ime and restores till that
time?
Look at http://www.winnetmag.com/Article/Art...09/42009.html. If
that's not enough, I can send you my script.
Quentin
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0407080734.94bd55f@.posting.google.co m...
> Any one have implemented backup, recovery stored procedures which
> takes the uments for dbname, date, time ime and restores till that
> time?
|||Thanks for the reply. I am looking for centralized scripts where we
should able to able to restore any database by giving arguments as DB
name, time, standby restore/normal restore. We should able to run it
from centralized server. Any ideas?
"Quentin Ran" <ab@.who.com> wrote in message news:<uulGraTZEHA.2388@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Look at http://www.winnetmag.com/Article/Art...09/42009.html. If
> that's not enough, I can send you my script.
> Quentin
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0407080734.94bd55f@.posting.google.co m...

Backup and restore scripts

Any one have implemented backup, recovery stored procedures which
takes the uments for dbname, date, time ime and restores till that
time?Look at http://www.winnetmag.com/Article/ArticleID/42009/42009.html. If
that's not enough, I can send you my script.
Quentin
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0407080734.94bd55f@.posting.google.com...
> Any one have implemented backup, recovery stored procedures which
> takes the uments for dbname, date, time ime and restores till that
> time?|||Thanks for the reply. I am looking for centralized scripts where we
should able to able to restore any database by giving arguments as DB
name, time, standby restore/normal restore. We should able to run it
from centralized server. Any ideas?
"Quentin Ran" <ab@.who.com> wrote in message news:<uulGraTZEHA.2388@.TK2MSFTNGP11.phx.gbl>...
> Look at http://www.winnetmag.com/Article/ArticleID/42009/42009.html. If
> that's not enough, I can send you my script.
> Quentin
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0407080734.94bd55f@.posting.google.com...
> > Any one have implemented backup, recovery stored procedures which
> > takes the uments for dbname, date, time ime and restores till that
> > time?

Backup and restore scripts

Any one have implemented backup, recovery stored procedures which
takes the uments for dbname, date, time ime and restores till that
time?Look at http://www.winnetmag.com/Article/Ar...009/42009.html. If
that's not enough, I can send you my script.
Quentin
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0407080734.94bd55f@.posting.google.com...
> Any one have implemented backup, recovery stored procedures which
> takes the uments for dbname, date, time ime and restores till that
> time?|||Thanks for the reply. I am looking for centralized scripts where we
should able to able to restore any database by giving arguments as DB
name, time, standby restore/normal restore. We should able to run it
from centralized server. Any ideas?
"Quentin Ran" <ab@.who.com> wrote in message news:<uulGraTZEHA.2388@.TK2MSFTNGP11.phx.gbl>...[
vbcol=seagreen]
> Look at http://www.winnetmag.com/Article/Ar...009/42009.html. If
> that's not enough, I can send you my script.
> Quentin
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0407080734.94bd55f@.posting.google.com...

backup and restore

On a production server, I do a full backup monthly and then delete data
from the tables that is older than the current date. On a separate
non-production server I restored the initial full backup. My question
is how can I add/restore the subsequent backups to the non-production
server with out stepping on the data that was initially restored?
Thanks,
Daniel<danielsmith611@.gmail.com> wrote in message
news:1155141011.175566.161350@.m73g2000cwd.googlegroups.com...
> On a production server, I do a full backup monthly and then delete data
> from the tables that is older than the current date. On a separate
> non-production server I restored the initial full backup. My question
> is how can I add/restore the subsequent backups to the non-production
> server with out stepping on the data that was initially restored?
>
RESTORE WITH MOVE, followed perhaps by merging the data.
EG
BACKUP DATABASE AdventureWorks
TO AdventureWorksBackups ;
RESTORE DATABASE AdventureWorks_200608
FROM AdventureWorksBackups
WITH MOVE 'AdventureWorks_Data' TO
'C:\MySQLServer\AdventureWorks_200608.mdf',
MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\AdventureWorks_200608.ldf';
David|||Do you have an example of the merge?
David Browne wrote:
> <danielsmith611@.gmail.com> wrote in message
> news:1155141011.175566.161350@.m73g2000cwd.googlegroups.com...
>
> RESTORE WITH MOVE, followed perhaps by merging the data.
>
> EG
> BACKUP DATABASE AdventureWorks
> TO AdventureWorksBackups ;
>
> RESTORE DATABASE AdventureWorks_200608
> FROM AdventureWorksBackups
> WITH MOVE 'AdventureWorks_Data' TO
> 'C:\MySQLServer\AdventureWorks_200608.mdf',
> MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\AdventureWorks_200608.ldf'
;
>
> David|||Or would log shipping work?
danielp wrote:[vbcol=seagreen]
> Do you have an example of the merge?
> David Browne wrote:|||"danielp" <danielsmith611@.gmail.com> wrote in message
news:1155158638.423828.3310@.h48g2000cwc.googlegroups.com...
> Or would log shipping work?
No. Your deletes would get shipped.
David|||"danielp" <danielsmith611@.gmail.com> wrote in message
news:1155149678.373420.184490@.i3g2000cwc.googlegroups.com...
> Do you have an example of the merge?
It's just SQL, or perhaps an SSIS package. What do the tables look like?
David

backup and restore

On a production server, I do a full backup monthly and then delete data
from the tables that is older than the current date. On a separate
non-production server I restored the initial full backup. My question
is how can I add/restore the subsequent backups to the non-production
server with out stepping on the data that was initially restored?
Thanks,
Daniel<danielsmith611@.gmail.com> wrote in message
news:1155141011.175566.161350@.m73g2000cwd.googlegroups.com...
> On a production server, I do a full backup monthly and then delete data
> from the tables that is older than the current date. On a separate
> non-production server I restored the initial full backup. My question
> is how can I add/restore the subsequent backups to the non-production
> server with out stepping on the data that was initially restored?
>
RESTORE WITH MOVE, followed perhaps by merging the data.
EG
BACKUP DATABASE AdventureWorks
TO AdventureWorksBackups ;
RESTORE DATABASE AdventureWorks_200608
FROM AdventureWorksBackups
WITH MOVE 'AdventureWorks_Data' TO
'C:\MySQLServer\AdventureWorks_200608.mdf',
MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\AdventureWorks_200608.ldf';
David|||Do you have an example of the merge?
David Browne wrote:
> <danielsmith611@.gmail.com> wrote in message
> news:1155141011.175566.161350@.m73g2000cwd.googlegroups.com...
> > On a production server, I do a full backup monthly and then delete data
> > from the tables that is older than the current date. On a separate
> > non-production server I restored the initial full backup. My question
> > is how can I add/restore the subsequent backups to the non-production
> > server with out stepping on the data that was initially restored?
> >
>
> RESTORE WITH MOVE, followed perhaps by merging the data.
>
> EG
> BACKUP DATABASE AdventureWorks
> TO AdventureWorksBackups ;
>
> RESTORE DATABASE AdventureWorks_200608
> FROM AdventureWorksBackups
> WITH MOVE 'AdventureWorks_Data' TO
> 'C:\MySQLServer\AdventureWorks_200608.mdf',
> MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\AdventureWorks_200608.ldf';
>
> David|||Or would log shipping work?
danielp wrote:
> Do you have an example of the merge?
> David Browne wrote:
> > <danielsmith611@.gmail.com> wrote in message
> > news:1155141011.175566.161350@.m73g2000cwd.googlegroups.com...
> > > On a production server, I do a full backup monthly and then delete data
> > > from the tables that is older than the current date. On a separate
> > > non-production server I restored the initial full backup. My question
> > > is how can I add/restore the subsequent backups to the non-production
> > > server with out stepping on the data that was initially restored?
> > >
> >
> >
> > RESTORE WITH MOVE, followed perhaps by merging the data.
> >
> >
> > EG
> >
> > BACKUP DATABASE AdventureWorks
> > TO AdventureWorksBackups ;
> >
> >
> > RESTORE DATABASE AdventureWorks_200608
> > FROM AdventureWorksBackups
> > WITH MOVE 'AdventureWorks_Data' TO
> > 'C:\MySQLServer\AdventureWorks_200608.mdf',
> > MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\AdventureWorks_200608.ldf';
> >
> >
> > David|||"danielp" <danielsmith611@.gmail.com> wrote in message
news:1155158638.423828.3310@.h48g2000cwc.googlegroups.com...
> Or would log shipping work?
No. Your deletes would get shipped.
David|||"danielp" <danielsmith611@.gmail.com> wrote in message
news:1155149678.373420.184490@.i3g2000cwc.googlegroups.com...
> Do you have an example of the merge?
It's just SQL, or perhaps an SSIS package. What do the tables look like?
David

Backup

Hello,
Newbie question.
How do I have have a complete backup of a database for one weeks time frame
and the backups append to the file name the date it was backup up? Anything
after a week the oldest backup will be deleted. Thank you.There is nothing in SQL Server that does exactly that for you. You can
accomplish the same thing with a bit of TSQL programming. Just one thing:
you cannot delete parts of a backup file. When you do a backup, it is either
all or nothing (append or overwrite).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"vpont" <anonymous@.discussions.microsoft.com> wrote in message
news:B4A8313C-1472-400D-BCD2-4EA7C4DEC18B@.microsoft.com...
> Hello,
> Newbie question.
> How do I have have a complete backup of a database for one weeks time
frame and the backups append to the file name the date it was backup up?
Anything after a week the oldest backup will be deleted. Thank you.

Backup

Is it possible to take backup of database for 1 day change?
also possible to restore it back for the particular date?
for example..
In one month data of database I want to take a backup for changes in 13 of
the month.
if required restore it back.
--
WM_QUIT
RLNI'm not sure what you want to accomplish. Are you saying that you want to restore the database as it
were at a certain point in time? If so, then you need to look into doing transaction log backups, as
they give you the ability to perform point-in-time restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:77A5FB86-2765-4036-AA4A-4BA93CA767CB@.microsoft.com...
> Is it possible to take backup of database for 1 day change?
> also possible to restore it back for the particular date?
> for example..
> In one month data of database I want to take a backup for changes in 13 of
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN