Re: Scheduling a Daily Backup of a SQL Database

history for the job step usually has some more details. Did you install Integration Services (or
apply sp1)?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"PM" <PM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:177A980A-9E1C-42D9-BD5E-8B7C7E8D9FEC@xxxxxxxxxxxxxxxx
Thanks very much guys, your help was very valuable.

I have another question, now. I created the Maintenance Plan using the
options I need. However, the maintenance plan does NOT run. It fails with
an 'Execution Failed' error message. It says to see the SQL Agent job
history logs, which I did. I did not get a much more helpful error message
there.

Where should I look for a more descriptive error message? Or, am I doing
something wrong that you'll recognize right away?

Thanks!

"Steen Schlüter Persson" wrote:


As already mentioned, you can check up Maintanance Plan in BOL, but you
should also notice if your databases are set to SIMPLE or FULL recovery
mode. If they are set to FULL, you'll need to back up the log as well where
as if they are only set to SIMPLE you just need to backup the database.

Also, just as important as the backup, is the restore...:-). As soon as you
have found out how to backup ypur databases, you should be sure that you are
able to restore them from the backup. I think we all have heard about
companies backing up their databases everyday just to find out that the
backup doesn't work when they need it.


--
Regards
Steen Schlüter Persson (DK)


"PM" <PM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1CD7323B-382B-4F66-B0E9-7DBEC0BB29B1@xxxxxxxxxxxxxxxx
Hello, I am very new to SQL server. I am supporting an application that
uses
SQL Server 2008 Standard for its database.

I have a very simple question. My research has pointed me to multiple
answers, and I am not certain which to go with.

Here is what I want to do: I want to schedule a NIGHTLY backup of this
particular SQL database. I want the NAME of the backup to contain the
date.
The backup destination will simply be an external hard drive.

So, after 20 days, there should be 20 backups in there. The names would
be
something like: Database-09022009.BAK.

Can someone help me? I'd like to know the best/simplest way to do this
with
SQL Server 2008 Standard.

Thank you.
PM





.

Relevant Pages

  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... Deletes old backup files ... In the job history for 'Nightly backup' is that job listed as passed ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (microsoft.public.sqlserver.tools)
  • Re: Backing Up Mirrored database
    ... Tibor Karaszi, SQL Server MVP ... > all databases; and both run successfully without any issues. ... "Attempt to backup but receives an error message from the engine so the job fails"? ...
    (microsoft.public.sqlserver.tools)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
  • Re: Sharepoint DB maintenance?
    ... options to backup nightly. ... I am more concerned abouthe maintenance (i.e. SQL maintenance?) stuff. ... It's a good idea to back up the SPS databases regularly. ... on the server that is running SQL Server 2000." ...
    (microsoft.public.sharepoint.portalserver)
  • Re: scheduled jobs
    ... Not all info is written to the backup ... history tables! ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
Loading