Backup script

I want to create a simple SQL 2005 database backup script to run a scheduled
times. This was easy with SQL 2000 but I can't find a similar process in
2005. Can anyone tell me where I can find it? Thanks.
DavidDavid,
In SQL Server Management Studio under the node Management / Maintenance
Plans you can create a maintenance plan using the Maintenance Plan Wizard
that backs up the databases. If you back up to disk using the appropriate
BACK UP DATABASE settings you should also be sure to check and fill out the
information for the MAINTENANCE CLEANUP TASK so that old backups get
deleted.
Is that what you are looking for?
RLF
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:OFL4DY5MIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I want to create a simple SQL 2005 database backup script to run a
>scheduled times. This was easy with SQL 2000 but I can't find a similar
>process in 2005. Can anyone tell me where I can find it? Thanks.
> David
>|||Alternatively,
In SQL Server 2005 every nearly window is scriptable. So, go to a database
and right click on it and Tasks\Back up... make your changes from the GUI
and you'll see a button on top of the Back Up Database window which is
labeled "Script". There is an arrow near it, click on it and you'll see your
choices.
You can use these scripts to create Jobs from the SQL Server Agent.
--
Ekrem Önsoy
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:OFL4DY5MIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I want to create a simple SQL 2005 database backup script to run a
>scheduled times. This was easy with SQL 2000 but I can't find a similar
>process in 2005. Can anyone tell me where I can find it? Thanks.
> David
>|||Thank you both. That is what I needed.
David
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:D82FA9CF-70A7-4802-A7C2-8C1BA3B053E8@.microsoft.com...
> Alternatively,
> In SQL Server 2005 every nearly window is scriptable. So, go to a database
> and right click on it and Tasks\Back up... make your changes from the GUI
> and you'll see a button on top of the Back Up Database window which is
> labeled "Script". There is an arrow near it, click on it and you'll see
> your choices.
> You can use these scripts to create Jobs from the SQL Server Agent.
> --
> Ekrem Önsoy
>
> "David C" <dlchase@.lifetimeinc.com> wrote in message
> news:OFL4DY5MIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I want to create a simple SQL 2005 database backup script to run a
>>scheduled times. This was easy with SQL 2000 but I can't find a similar
>>process in 2005. Can anyone tell me where I can find it? Thanks.
>> David
>

Backup Questions

If I have a full backup scheduled at 6pm and a scheduled transaction log backup begins during the 15 minutes the full takes to complete, how would I use the transaction log backup during a recovery sequence?

Does the transaction log backup contain transactions that are captured in the full recovery since they both occured concurrently? Using RESTORE HEADERONLY I see they both are stamped as finishing at the same time.

Would I restore the full and then restore this tran log backup or go to the next tran log backup?

Thanks,
KenThe rule is that tran log backups can only apply to the previous full backup. You should adjust your tran log schedule so that it's not running while the full backup is running. Your tran log backp, the one that finished 'at the same time' as the full backup is of no use. However, if you use Enterprise Manager and go throught the Restore window and show history, you can see the sequence of tran log backups relative to the full backup.

If you use Maintenance Plans, you can create a backup plan. However, if you decide to do it yourself using jobs, dump devices and so on, you will have more work on your hands to sort it out correctly. I personally think the extra work is worthwhile expecially for important systems - the ones you can't afford to lose.

My advice is to understand these issues very clearly and do some test restores into another database using differing database recovery scenarios.

Clive

backup problem

Hello,

This backup plan i have that works fine when i trigger it manually does not work when scheduled, here is the output of the error I am getting, I am new to sql 2005 and i really need to get this working fast, and dont have alot of time to research the problem right now.

Tdar

Error Message:

05/12/2007 00:00:01,daily backup.Subplan_1,Error,1,IPDDFZ2363ATL2,daily backup.Subplan_1,Subplan_1,,Executed as user: IPDDFZ2363ATL2\MSSQL_USER. ...42.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:00:01 AM Error: 2007-05-12 00:00:20.92 Code: 0xC00291EC Source: {C4C38724-5AEF-4472-9CC9-E24587B74591} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2007-05-12 00:00:20.93 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded<c/> but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2007-05-12 00:00:21.51 Code: 0xC0024104 Source: Back Up Database (Full) ... The package execution fa... The step failed.,00:00:20,0,0,,,,0
05/11/2007 00:00:00,daily backup.Subplan_1,Error,0,IPDDFZ2363ATL2,daily backup.Subplan_1,(Job outcome),,The job failed. The Job was invoked by Schedule 3 (BACKTEST). The last step to run was step 1 (Subplan_1).,00:00:15,0,0,,,,0

Typically, when you are able to run something (espeically DTS) by hand but it fails to work when you schedule it, it is a permissions issue. Check to see which user the job is running under and give that user the permission to execute what needs to be executed.

Tim

backup over ip and compress with rar

Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
J
You may want to use SQL LiteSpeed instead: www.imceda.com.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:uL1R6KCFFHA.2052@.TK2MSFTNGP09.phx.gbl...
Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
J

backup over ip and compress with rar

Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
JYou may want to use SQL LiteSpeed instead: www.imceda.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:uL1R6KCFFHA.2052@.TK2MSFTNGP09.phx.gbl...
Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
J

backup over ip and compress with rar

Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
JYou may want to use SQL LiteSpeed instead: www.imceda.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:uL1R6KCFFHA.2052@.TK2MSFTNGP09.phx.gbl...
Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
J

Backup of Databases

For a static READ Only database with no scheduled job, is there any
databases other than those mentioned below I have to make a backup for
recovery purpose ?
1) User Database
2) Master
3) MSDB
Thanks
"Stephen" schrieb:
> For a static READ Only database with no scheduled job, is there any
> databases other than those mentioned below I have to make a backup for
> recovery purpose ?
> 1) User Database
> 2) Master
> 3) MSDB
> Thanks
No. With no scheduled jobs you probably don't even need the msdb (if there's
no alerts, operators, or email support defined).
The master db is only needed to restore the logins that might map to db user
accounts.
The user db is generally restorable without any system db restore (that's
why you can restore a user db on any given SQL Server ...).
|||Hi,
You are good enough.
If it is a read only database, then you could backup the database once and
keep it in a safe location. This includes all your system databases
(Master and MSDB) as well as your user databases.
Thanks
Hari
SQL Server MVP
"Stephen" <anonymous@.discussions.microsoft.com> wrote in message
news:%23h5mcSXeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> For a static READ Only database with no scheduled job, is there any
> databases other than those mentioned below I have to make a backup for
> recovery purpose ?
> 1) User Database
> 2) Master
> 3) MSDB
> Thanks
>

Backup of Databases

For a static READ Only database with no scheduled job, is there any
databases other than those mentioned below I have to make a backup for
recovery purpose ?
1) User Database
2) Master
3) MSDB
Thanks"Stephen" schrieb:
> For a static READ Only database with no scheduled job, is there any
> databases other than those mentioned below I have to make a backup for
> recovery purpose ?
> 1) User Database
> 2) Master
> 3) MSDB
> Thanks
No. With no scheduled jobs you probably don't even need the msdb (if there's
no alerts, operators, or email support defined).
The master db is only needed to restore the logins that might map to db user
accounts.
The user db is generally restorable without any system db restore (that's
why you can restore a user db on any given SQL Server ...).|||Hi,
You are good enough.
If it is a read only database, then you could backup the database once and
keep it in a safe location. This includes all your system databases
(Master and MSDB) as well as your user databases.
Thanks
Hari
SQL Server MVP
"Stephen" <anonymous@.discussions.microsoft.com> wrote in message
news:%23h5mcSXeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> For a static READ Only database with no scheduled job, is there any
> databases other than those mentioned below I have to make a backup for
> recovery purpose ?
> 1) User Database
> 2) Master
> 3) MSDB
> Thanks
>

Backup of Databases

For a static READ Only database with no scheduled job, is there any
databases other than those mentioned below I have to make a backup for
recovery purpose ?
1) User Database
2) Master
3) MSDB
Thanks"Stephen" schrieb:
> For a static READ Only database with no scheduled job, is there any
> databases other than those mentioned below I have to make a backup for
> recovery purpose ?
> 1) User Database
> 2) Master
> 3) MSDB
> Thanks
No. With no scheduled jobs you probably don't even need the msdb (if there's
no alerts, operators, or email support defined).
The master db is only needed to restore the logins that might map to db user
accounts.
The user db is generally restorable without any system db restore (that's
why you can restore a user db on any given SQL Server ...).|||Hi,
You are good enough.
If it is a read only database, then you could backup the database once and
keep it in a safe location. This includes all your system databases
(Master and MSDB) as well as your user databases.
Thanks
Hari
SQL Server MVP
"Stephen" <anonymous@.discussions.microsoft.com> wrote in message
news:%23h5mcSXeFHA.3864@.TK2MSFTNGP10.phx.gbl...
> For a static READ Only database with no scheduled job, is there any
> databases other than those mentioned below I have to make a backup for
> recovery purpose ?
> 1) User Database
> 2) Master
> 3) MSDB
> Thanks
>

Backup locations

I need to set up SQL (preferably in a DB Maint Plan) to do scheduled backups, but place them on a mapped drive. (Running out of room on my server!) Whenever I try to set anything up, I can only "see" the local drives. I've tried it mapped and UNC. I've also made sure that both the server's logins appear on both machines and have permissions on the shared folder. What am I missing' Any help would be greatly appreciated
Thanks
TinaMethod 1: Create your maintenance plan and pick an
arbitrary backup directory. When you have finished
creating the plan, go to the Jobs under SQL Server Agent
and modify the DB backup Job for the maintenance plan. The
T-SQL in the job step should be something like:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 1115857B-656B-
4064-9F7A-5BD2C6C1A2E6 -BkUpMedia DISK -
BkUpDB "e:\MSSQLBackup" -BkExt "BAK"'
Change the value following -BkUpDB to a UNC of your choice.
Method 2: Forget about the maintenance plan and create a
SQL Server Agent backup job yourself with the BACKUP
statement. You can then specify whatever UNC you fancy,
assuming there is no permission issue.
Linchi
>--Original Message--
>I need to set up SQL (preferably in a DB Maint Plan) to
do scheduled backups, but place them on a mapped drive.
(Running out of room on my server!) Whenever I try to set
anything up, I can only "see" the local drives. I've tried
it mapped and UNC. I've also made sure that both the
server's logins appear on both machines and have
permissions on the shared folder. What am I missing' Any
help would be greatly appreciated.
>Thanks!
>Tina
>.
>|||Enterprise Mangler will only show local drives. SQL cannot use mapped
drives consistantly because the SQL Service may not see the same mappings as
the console login. The solution is to type the UNC name of the folder in
the target location field.
You also have to make sure that SQL Server can write files to that location.
The easiest way is for you to run SQL under a domain-level account and give
that account permissions on the target folder. Use the following SQL Script
to test access.
xp_cmdshell 'dir \\MyUNCRemote\ShareName'
I suggest giving FULL CONTROL on the target folder to the SQL Service
account. Make sure you have both share permission and underlying NTFS
permissions set correctly.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Tina Tysinger" <ttysinger@.co.hernando.fl.us> wrote in message
news:2D848E29-A745-4682-B70A-D549A2760558@.microsoft.com...
> I need to set up SQL (preferably in a DB Maint Plan) to do scheduled
backups, but place them on a mapped drive. (Running out of room on my
server!) Whenever I try to set anything up, I can only "see" the local
drives. I've tried it mapped and UNC. I've also made sure that both the
server's logins appear on both machines and have permissions on the shared
folder. What am I missing' Any help would be greatly appreciated.
> Thanks!
> Tina

backup jobs not runing on mssql7

Hi there,
I have a mssql-7 and 2/5 dbs get backed up nightly through
the scheduled backup jobs. 3 dbs keep failing at nights
and if I run the job manually. I can manually backup the
DBs through ALL TASKS..BACKUP DATABASE.
I've Checked:
SP-4
service running
sql agent running as admin
Job enabled
MDAC (latest)
jobs are 15mins apart
Any suggestions are appriciated.
ThanXHave you checked the logs and Agent history? What is the error that gets
produced?
Andrew J. Kelly SQL MVP
"Emil" <anonymous@.discussions.microsoft.com> wrote in message
news:ed5901c43d33$cbb41660$a101280a@.phx.gbl...
> Hi there,
> I have a mssql-7 and 2/5 dbs get backed up nightly through
> the scheduled backup jobs. 3 dbs keep failing at nights
> and if I run the job manually. I can manually backup the
> DBs through ALL TASKS..BACKUP DATABASE.
> I've Checked:
> SP-4
> service running
> sql agent running as admin
> Job enabled
> MDAC (latest)
> jobs are 15mins apart
> Any suggestions are appriciated.
> ThanX
>|||Andrew,
I have cheched the agent log and its clean! and the server
log doesn't mention anything regarding the job failure.
ThanX
>--Original Message--
>Have you checked the logs and Agent history? What is the
error that gets
>produced?
>--
>Andrew J. Kelly SQL MVP
>
>"Emil" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ed5901c43d33$cbb41660$a101280a@.phx.gbl...
through[vbcol=seagreen]
>
>.
>|||What about the Job History? Right click on thjob in EM and choose Show
History. Then check the checkbox labeled Show Details and see what that
says.
Andrew J. Kelly SQL MVP
"Emil" <anonymous@.discussions.microsoft.com> wrote in message
news:f29b01c43dad$56d3bc90$a601280a@.phx.gbl...[vbcol=seagreen]
> Andrew,
> I have cheched the agent log and its clean! and the server
> log doesn't mention anything regarding the job failure.
> ThanX
> error that gets
> message
> through

backup jobs not runing on mssql7

Hi there,
I have a mssql-7 and 2/5 dbs get backed up nightly through
the scheduled backup jobs. 3 dbs keep failing at nights
and if I run the job manually. I can manually backup the
DBs through ALL TASKS..BACKUP DATABASE.
I've Checked:
SP-4
service running
sql agent running as admin
Job enabled
MDAC (latest)
jobs are 15mins apart
Any suggestions are appriciated.
ThanX
Have you checked the logs and Agent history? What is the error that gets
produced?
Andrew J. Kelly SQL MVP
"Emil" <anonymous@.discussions.microsoft.com> wrote in message
news:ed5901c43d33$cbb41660$a101280a@.phx.gbl...
> Hi there,
> I have a mssql-7 and 2/5 dbs get backed up nightly through
> the scheduled backup jobs. 3 dbs keep failing at nights
> and if I run the job manually. I can manually backup the
> DBs through ALL TASKS..BACKUP DATABASE.
> I've Checked:
> SP-4
> service running
> sql agent running as admin
> Job enabled
> MDAC (latest)
> jobs are 15mins apart
> Any suggestions are appriciated.
> ThanX
>
|||Andrew,
I have cheched the agent log and its clean! and the server
log doesn't mention anything regarding the job failure.
ThanX
>--Original Message--
>Have you checked the logs and Agent history? What is the
error that gets
>produced?
>--
>Andrew J. Kelly SQL MVP
>
>"Emil" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:ed5901c43d33$cbb41660$a101280a@.phx.gbl...
through
>
>.
>
|||What about the Job History? Right click on thjob in EM and choose Show
History. Then check the checkbox labeled Show Details and see what that
says.
Andrew J. Kelly SQL MVP
"Emil" <anonymous@.discussions.microsoft.com> wrote in message
news:f29b01c43dad$56d3bc90$a601280a@.phx.gbl...[vbcol=seagreen]
> Andrew,
> I have cheched the agent log and its clean! and the server
> log doesn't mention anything regarding the job failure.
> ThanX
> error that gets
> message
> through

backup jobs not runing on mssql7

Hi there,
I have a mssql-7 and 2/5 dbs get backed up nightly through
the scheduled backup jobs. 3 dbs keep failing at nights
and if I run the job manually. I can manually backup the
DBs through ALL TASKS..BACKUP DATABASE.
I've Checked:
SP-4
service running
sql agent running as admin
Job enabled
MDAC (latest)
jobs are 15mins apart
Any suggestions are appriciated.
ThanXHave you checked the logs and Agent history? What is the error that gets
produced?
--
Andrew J. Kelly SQL MVP
"Emil" <anonymous@.discussions.microsoft.com> wrote in message
news:ed5901c43d33$cbb41660$a101280a@.phx.gbl...
> Hi there,
> I have a mssql-7 and 2/5 dbs get backed up nightly through
> the scheduled backup jobs. 3 dbs keep failing at nights
> and if I run the job manually. I can manually backup the
> DBs through ALL TASKS..BACKUP DATABASE.
> I've Checked:
> SP-4
> service running
> sql agent running as admin
> Job enabled
> MDAC (latest)
> jobs are 15mins apart
> Any suggestions are appriciated.
> ThanX
>|||Andrew,
I have cheched the agent log and its clean! and the server
log doesn't mention anything regarding the job failure.
ThanX
>--Original Message--
>Have you checked the logs and Agent history? What is the
error that gets
>produced?
>--
>Andrew J. Kelly SQL MVP
>
>"Emil" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ed5901c43d33$cbb41660$a101280a@.phx.gbl...
>> Hi there,
>> I have a mssql-7 and 2/5 dbs get backed up nightly
through
>> the scheduled backup jobs. 3 dbs keep failing at nights
>> and if I run the job manually. I can manually backup the
>> DBs through ALL TASKS..BACKUP DATABASE.
>> I've Checked:
>> SP-4
>> service running
>> sql agent running as admin
>> Job enabled
>> MDAC (latest)
>> jobs are 15mins apart
>> Any suggestions are appriciated.
>> ThanX
>>
>
>.
>|||What about the Job History? Right click on thjob in EM and choose Show
History. Then check the checkbox labeled Show Details and see what that
says.
--
Andrew J. Kelly SQL MVP
"Emil" <anonymous@.discussions.microsoft.com> wrote in message
news:f29b01c43dad$56d3bc90$a601280a@.phx.gbl...
> Andrew,
> I have cheched the agent log and its clean! and the server
> log doesn't mention anything regarding the job failure.
> ThanX
> >--Original Message--
> >Have you checked the logs and Agent history? What is the
> error that gets
> >produced?
> >
> >--
> >Andrew J. Kelly SQL MVP
> >
> >
> >"Emil" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:ed5901c43d33$cbb41660$a101280a@.phx.gbl...
> >> Hi there,
> >> I have a mssql-7 and 2/5 dbs get backed up nightly
> through
> >> the scheduled backup jobs. 3 dbs keep failing at nights
> >> and if I run the job manually. I can manually backup the
> >> DBs through ALL TASKS..BACKUP DATABASE.
> >>
> >> I've Checked:
> >> SP-4
> >> service running
> >> sql agent running as admin
> >> Job enabled
> >> MDAC (latest)
> >> jobs are 15mins apart
> >>
> >> Any suggestions are appriciated.
> >> ThanX
> >>
> >>
> >
> >
> >.
> >

Backup jobs and restores reporting false success!

Below are the problems I am having with my SQL 7.0
server. The first problem is backup jobs created with
the backup wizard and scheduled with the backup wizard
fail. The latest problem I discovered is my databases
can not be restored. The restore problem is very
critical to solve.
I tested restoring a database and the system reports the
database is restore sucessfully but it does not. The
sysdatabase does not show an entry for the restored
database. When I close Enterprise Manager and reopen the
database is gone. The mdf file is still in the data
directory. What is wrong with my sql server.
I can restore the database from the same file on my SQL
2000 server but it fail on every one of the SQL 7.0
servers. The production 7.0 SQL server and the 7.0 SQL
server on my laptop computer.
Kathy
The first point you made really made sense to me. I knew
transactions rolled back but never thought about a backup
job rolling back. I did as you suggested. I created a
backup device and backup a database (and restored it)
using T-SQL code. Of course this worked, because it is
not a job scheduled using the backup wizard interface. I
can always manually backup a database by right clicking,
choicing "All Task" and "Backup Database." But as soon
as I ran it as a scheduled job it will failed, or SQL
would reported it as suceeding with no BAK file.
So, I decided to create a backup job manually. It
worked!!! Then I scheduled it through the job interfaced
and it ran as scheduled.
To clarify this to you:
Backup Job FAILS when I do the following steps:
Create a backup device, i.e. otg_backupdevice
Right click on the new backup device (otg_backupdevice)
and select "Backup a Database"
The SQL Server backup wizard window appears, select the
database (otg) to backup, add the backup device
(otg_backupdevice) and schedule the backup to occur once
a day at 12:00 A.M.
Then ran the job from the jobs window
The job fails.
Backup Job Succeeds when I do the following steps:
Create a backup device, i.e. otg_backupdevice
Go to the job window
Right-click and select new job
Name the job - OTG backup to device
Click on the "Steps" tab and click on "New Step"
Select OTG as the database
In the command window I enter "backup database otg to
otg_backupdevice
Click on the "Schedule" tab and schedule it to backup at
10:00 am
The job suceeds
I suspect there is a problem with the backup wizard'
I am experiencing the same behavior on my SQL Server 7.0
running on NT (lastest service packs and patched on
both.) I too have witnessed the BAK file created and
then
deleted. I do not have the maintance plan configured to
deleting old .BAK files. I do receive this error message
when I create a backup from the "backup" option (not the
database maintenance plan.) This is the message I get:
10 percent backed up. [SQLSTATE 01000] (Message 3211) 20
percent backed up. [SQLSTATE 01000] (Message 3211)
ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message
258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) 30 percent
backed up. [SQLSTATE 01000] (Message 3211). The step
failed.
NOTE: I am backing up to the server harddrive(NO NETWORK
INVOLVED!!!)with 20 gigs free. This database is only
199mb in size. I suspect the "general network error" is
bogus.
Please help!
>--Original Message--
>been researching a problem I discovered yesterday on the
>SQLSever 7.0 I administer. I discovered Call Heller
>posted a problem very similar to what I am
experiencing.
>
>Every morning I check to see if my SQL backup jobs run.
>No errors are reported. Yesterday, I was ask to restore
a
>database and discovered there was not output file i.e.
>teachercert_db_200308201656.BAK. I viewed job log,
>backup maintenance plan history and event viewer, all
>reported that the output file was created. Now, if I go
>in and manual backup the database directly from the
>database "All Task" option, an output file is created.
>
>Next I discovered all the database maintenance plans I
>viewed on changed yesterday, did not generate an output
>file when the scheduled job ran.
>
>My questions are:
>
>1. Why is the job not generating a output file and
all
>log report the output file was created?
>2. How do I open a case with Microsoft
>
>I'd appreciate any help you can offer.
>
>Kathy Long
>
>.
>It seems that you can create a backup job successfully just have
problems with the wizard.
Do you mean the maintenance exe? I always advise against using that so I
would say stick with simplest solution.
Instead of creating a device use backup dateabase dbname to disk = ...
This will create a backup file for you.
I always include the date and time in the filename to make
administration easier.
Here is an SP that will backup all databases on a server - you can get
some ideas from that:
http://www.nigelrivett.net/BackupAllDatabases.html
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Hi Kathy,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
About the backup wizard to backup the database, I have provided solution
and you can try the steps I provided and if there is any problem, please
feel free to post any new message in that post and I am pleased and ready
to provide support there.
In this post, I will assist you to solve the prolem of restore your
database in SQL Server 7.0. I will work on it today. But please go to the
old post to check if the backup problem is solved.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Kathy,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
From the information you provided, your problem should be:
You want to restore database from a file. This process succeeded in SQL
Server 2000 but failed in SQL Server 7.
Actually, because the information you provide is so limited, I cannot give
an answer or solution this time. I wonder if you could provide the
information below for further analysis:
1) When using the Enterprise Manager to restore the database, what steps
have you taken? Could you give me more detailed information? Because you
just said you restored a database, but it is gone. I just want to the
detailed information of how you carry out this restore process, by T-SQL or
by Wizard? Have you got any message indicate that the restore is successful
or failed, what is these messages? Could you provide the System and
Application logs together with the output of SQLDiag if they are available
to you?
2) What kind of file you are using in this backup process? Is the file you
used the MDF file you mentioned above? If not, is it a SQL Server 2000
backup file or a SQL Server 7 backup file?
The feedback from you will be great helpful in clarifying the problem you
encountered and for us to analysis. I am waiting on your response and ready
to provide further help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||1. Steps to Enterprise manager is to right click on the
database to restore the backup file to and select the
file I want to use. Then on the Option tab I choice to
restore over the current database and change the path to
E:\Data\Test.mdb. The system clains it restore correctly
but when I attempt to open up the database I receive this
message: Error 911- could not locate entry in
sysdatabase 'Test.' No entry found with that name. Make
sure that the name is entered correctly.
I know the database is there because I still see it in
the file folder.
2. The file is created with SQL Server 7.0. I've used
backup devices and files.
When I do a manual using T-SQL restore to the same
database with the following command
RESTORE DATABASE PBDMI
FROM DISK = 'H:\PBDMI.bak'
I receive the following info in my results pane.
Processed 28968 pages for database 'PBDMI',
file 'PBDMI_Data' on file 1.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General
network error. Check your network documentation.
Processed 1 pages for database 'PBDMI', file 'PBDMI_Log'
on file 1.
Connection Broken
The database actually restores because I've deleted a row
in one of the tables and it comes back after the
restore. No luck restoring to a different database.
When I run the code to restore to a different database:
BACKUP DATABASE PBDMI
TO DISK = 'H:\PBDMI.bak'
RESTORE FILELISTONLY
FROM DISK = 'H:\PBDMI.bak'
RESTORE DATABASE PBDMI_New
FROM DISK = 'H:\PBDMI.bak'
WITH MOVE 'PBDMI' TO 'E:\Data\PBDMI_New_Data.mdf',
MOVE 'PBDMI_log' TO 'E:\Data\PBDMI_New_Log.ldf',
REPLACE
GO
Here is the message I receive. I pretty sure our
language is US-English
Changed language setting to us_english.
Processed 28968 pages for database 'PBDMI',
file 'PBDMI_Data' on file 6.
Processed 1 pages for database 'PBDMI', file 'PBDMI_Log'
on file 6.
Backup or restore operation successfully processed 28969
pages in 38.095 seconds (6.229 MB/sec).
LogicalName
PhysicalName
Type
FileGroupName
Size
MaxSize
----
----
-- ---
----
----
----
--- --
-- ----
----
-- -- --
--
PBDMI_Data
e:\data\PBDMI_Data.MDF
D
PRIMARY
240582656 35184372080640
PBDMI_Log
e:\data\PBDMI_Log.LDF
L
NULL
704905216 35184372080640
(2 row(s) affected)
Server: Msg 3234, Level 16, State 2, Line 9
File 'PBDMI' is not a database file for
database 'PBDMI_New'.
Server: Msg 3013, Level 16, State 1, Line 9
Backup or restore operation terminating abnormally.
I cannot send any file to your email address.
Thanks for your help.
Kathy
>--Original Message--
>Hi Kathy,
> Thank you for using MSDN Newsgroup! It's my pleasure to
assist you with
>your issue.
> From the information you provided, your problem should
be:
>You want to restore database from a file. This process
succeeded in SQL
>Server 2000 but failed in SQL Server 7.
>
>Actually, because the information you provide is so
limited, I cannot give
>an answer or solution this time. I wonder if you could
provide the
>information below for further analysis:
>1) When using the Enterprise Manager to restore the
database, what steps
>have you taken? Could you give me more detailed
information? Because you
>just said you restored a database, but it is gone. I
just want to the
>detailed information of how you carry out this restore
process, by T-SQL or
>by Wizard? Have you got any message indicate that the
restore is successful
>or failed, what is these messages? Could you provide
the System and
>Application logs together with the output of SQLDiag if
they are available
>to you?
>2) What kind of file you are using in this backup
process? Is the file you
>used the MDF file you mentioned above? If not, is it a
SQL Server 2000
>backup file or a SQL Server 7 backup file?
> The feedback from you will be great helpful in
clarifying the problem you
>encountered and for us to analysis. I am waiting on your
response and ready
>to provide further help!
>
>Best regards
>Baisong Wei
> Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>
>.
>

Backup job Fails every time:

Dear Friends!
I have a scheduled job on my production server which always fails. When I
see the job history step details I can see 100 % backedup and along with
that I receive error
[SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'SLNKMIL',
file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
step failed.
Pl, guide me. Job fail isn't affordable on my production database.
I sincerly thank you!
S.Lakshminarayanan.
Message posted via http://www.sqlmonster.com
Can you try issuing a BACKUP DATABASE statement via T-SQL through Query
Analyzer? It would be helpful to see the errors (if there are any). Before
running the backup make sure that you have results set to text.
The syntax is easy enough:
BACKUP DATABASE SLNKMIL TO DISK = 'x:\SLNKMIL.bak' WITH INIT
Keith
"lakshminarayan iyer via SQLMonster.com" <forum@.SQLMonster.com> wrote in
message news:67ccca76be724649be8629b2da37796a@.SQLMonster.c om...
> Dear Friends!
> I have a scheduled job on my production server which always fails. When I
> see the job history step details I can see 100 % backedup and along with
> that I receive error
> [SQLSTATE 01000] (Message 3211) Processed 1 pages for database
'SLNKMIL',
> file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
> step failed.
> Pl, guide me. Job fail isn't affordable on my production database.
> I sincerly thank you!
> S.Lakshminarayanan.
> --
> Message posted via http://www.sqlmonster.com
|||Is the database in Simple recovery mode? If so you can not do a log backup.
Andrew J. Kelly SQL MVP
"lakshminarayan iyer via SQLMonster.com" <forum@.SQLMonster.com> wrote in
message news:67ccca76be724649be8629b2da37796a@.SQLMonster.c om...
> Dear Friends!
> I have a scheduled job on my production server which always fails. When I
> see the job history step details I can see 100 % backedup and along with
> that I receive error
> [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'SLNKMIL',
> file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
> step failed.
> Pl, guide me. Job fail isn't affordable on my production database.
> I sincerly thank you!
> S.Lakshminarayanan.
> --
> Message posted via http://www.sqlmonster.com

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.
What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If you
define an output file for the jobstep, what error(s) do you see there?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and login as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprse Manager and how to fix
>it? Thanks.
>
|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>
|||This is what I got from output file:
************************************************** ************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
************************************************** *********************************
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>
|||So it is a TSQL job step. What database is it defined to run in? Make sure it runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKUP and RESTORE from the
master database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl...
> This is what I got from output file:
> ************************************************** ************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]
> ************************************************** *********************************
> pure is the database I want to backup. The strange things I realized is that John is the owner of
> the scheduled job but why guest user is involved in the scheduled job according to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If you
define an output file for the jobstep, what error(s) do you see there?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and login as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprse Manager and how to fix
>it? Thanks.
>|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The
>>scheduled backup job always failed no matter it manually run or scheduled.
>>I use query analyzer and login as john and copy the script from the job
>>and execute it and IT RUN. OK, I change the job owner to sa and it runs.
>>Can anyone please tell me why the job run in query analyzer but not in
>>Enterprse Manager and how to fix it? Thanks.
>|||This is what I got from output file:
**************************************************************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
***********************************************************************************
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The
>>scheduled backup job always failed no matter it manually run or scheduled.
>>I use query analyzer and login as john and copy the script from the job
>>and execute it and IT RUN. OK, I change the job owner to sa and it runs.
>>Can anyone please tell me why the job run in query analyzer but not in
>>Enterprse Manager and how to fix it? Thanks.
>|||So it is a TSQL job step. What database is it defined to run in? Make sure it runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKUP and RESTORE from the
master database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl...
> This is what I got from output file:
> **************************************************************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]
> ***********************************************************************************
> pure is the database I want to backup. The strange things I realized is that John is the owner of
> the scheduled job but why guest user is involved in the scheduled job according to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>> What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If
>> you define an output file for the jobstep, what error(s) do you see there?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> " -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job
>>always failed no matter it manually run or scheduled. I use query analyzer and login as john and
>>copy the script from the job and execute it and IT RUN. OK, I change the job owner to sa and it
>>runs. Can anyone please tell me why the job run in query analyzer but not in Enterprse Manager
>>and how to fix it? Thanks.
>>
>

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.What job step type? Is John an SQL Server or a Windows login? What exact err
or for the job? If you
define an output file for the jobstep, what error(s) do you see there?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl
..
>I have set up a scheduled backup job and the owner is set to john. The sch
eduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and log
in as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner
to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprs
e Manager and how to fix
>it? Thanks.
>|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>|||This is what I got from output file:
****************************************
**********************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
****************************************
************************************
*******
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>|||So it is a TSQL job step. What database is it defined to run in? Make sure i
t runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKU
P and RESTORE from the
master database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl..
.
> This is what I got from output file:
> ****************************************
**********************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09
:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure
'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
> ****************************************
**********************************
*********
> pure is the database I want to backup. The strange things I realized is th
at John is the owner of
> the scheduled job but why guest user is involved in the scheduled job acco
rding to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>

Backup files

Hi,
I have a scheduled maintenance plan for backing up my database.
I have recently ran out of space and I need to delete some old back up files.

Question:
if I make a backup of a database (full backup) if I want to restore my databse using the transaction logs I can only go back to the latest backup?
If so, why should I keep my old backup files?
Is there any way to tell sql server to overwrite backup files each time it makes a back up and is this a good idea?

thanksWhat I have done here is to have two scheduled maintenance plans for backing up. One that runs every 24 hours that overwrites every time, and a second that appends an incremental every three hours. We then store everything on tape for two weeks.

When you set up the job there is a radio button group to select overwrite or append. If you want to edit your job step change NOINIT to INIT and then the job will overwrite.

Originally posted by Sia
Hi,
I have a scheduled maintenance plan for backing up my database.
I have recently ran out of space and I need to delete some old back up files.

Question:
if I make a backup of a database (full backup) if I want to restore my databse using the transaction logs I can only go back to the latest backup?
If so, why should I keep my old backup files?
Is there any way to tell sql server to overwrite backup files each time it makes a back up and is this a good idea?

thanks