sql backup files: successfully

Showing posts with label successfully. Show all posts

Sunday, March 11, 2012

Backup Problem - multiple family members

I have a backup that has been working successfully for the past two months, but this weekend the following error message appeared.

"The media set for database 'MyDB' has 2 family members, but only 1 are provided. All members must be provided."

I checked the contents from the previous backups, and they all have 1 family member, and 1 media set?

Any ideas on what has changed, and what I need to do to fix this?i have encountered this. just delete your backup device from the harddisk totally then make a new backup device.

hope it should work for you.|||Thanks, that worked. Though I still wonder what caused the problem.

Originally posted by kenz
i have encountered this. just delete your backup device from the harddisk totally then make a new backup device.

hope it should work for you.

backup problem

I successfully deployed the AdventureWorks OLAP database to my 2005 Analysis Server and Backed it up under SQL Server Management Studio. When I tried to restore the backup to another sql 2005 Analysis Server the restore failed.

I went back to the "Backup" dialog box and noted that it would only "store database metadata to a specific location". Metadata only? How do I create a full backup that can be restored on another server and is ready for use?

TIA,

Barkingdog

Hi Barkingdog,

You should be able to backup AdventureWorks and restore it to another server. Can you let me know of what is the failure message when you restore the database on another server?

Yan Li

|||What is the storage mode used for your cube - if you are using ROLAP or HOLAP, the cube data is not backed up because cube data remains in the underlying data source - for all data and meta data to be backed up in the AS backup file in AS2K5, you must be using MOLAP are your storage mode.

Backup problem

Sorry if i am in wrong place. i read http://msdn2.microsoft.com/en-us/library/aa225964(SQL.80).aspx

the 1st two commond successfully executed

USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_2',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_2.dat'

--Create the log backup device.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwindLog1',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwindLog1.dat'

But following command gave me an error which is in the last of this post (red colored)

-- Back up the full MyNwind database.
BACKUP DATABASE test TO MyNwind_2

-- Update activity has occurred since the full database backup.

-- Back up the log of the MyNwind database.
BACKUP LOG test
TO MyNwindLog1

Msg 3201, Level 16, State 1, Line 11
Cannot open backup device 'MyNwind_2(c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_2.dat)'. Operating system error 5(Access is denied.).

The c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\

is valid location (i mean this folder exists)

Hi,

if you are using SQL Server Authentication you are authentication on the folder level with the Serice Account which is actually running the SQL Server Service. Make sure this one has the appropiate permissions to access the file path and create files in that folder. Using Windows Authentication will use the credentials of the current user to get access to the path, make then sure this your user has the appropiate permissions. WHat you have to keep in mind is, that the path you are provding here is a local server path, notone of the actual computer you are sending the query from (if you are using a client and do not work directly on the server). You will make sure that the path exists on the executing server.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Friday, February 24, 2012

Backup MSDE with NetBackup?

Has anyone been able to to successfully backup/restore MSDE databases via
Veritas NetBackup 5.0?
We backup SQL Server with its own Backup commands. It deals with "dirty"
data so you don't have to shutdown the server. These can be executed from
SQL-DMO or OSQL/ISQL scripts. See TSQL help for lots of examples.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Eric N. Darby" <eric@.NOSPAMNOWAY.com> wrote in message
news:%23IxiyVOeEHA.3680@.TK2MSFTNGP11.phx.gbl...
> Has anyone been able to to successfully backup/restore MSDE databases via
> Veritas NetBackup 5.0?
>
>

Thursday, February 16, 2012

Backup log - will it truncate?

According to BOL
<--
BACKUP LOG
Specifies a backup of the transaction log only. The log is backed up
from the last successfully executed LOG backup to the current end of
the log. Once the log is backed up, the space may be truncated when no
longer required by replication or active transactions.
--
Does this mean I could do something else to truncate the log or is it
saying that the backup log command may truncate the log if it feels
like it?

I want ot get a log from a client site onto my server for analysis but
I want ot make absolute certain that my backing up the log on their
server won't truncate it there.Trevor

A backup of the transaction log will truncate the transaction log. All
completed transactions will be removed.

What are you planing to do with the transaction log? There is not a lot
you can do with out a matching database. As far as I am aware,
Lumigent's Log reader is the only product that can read the transaction
log.

Regards

John

Trevor Best wrote:
> According to BOL
> <--
> BACKUP LOG
> Specifies a backup of the transaction log only. The log is backed up
> from the last successfully executed LOG backup to the current end of
> the log. Once the log is backed up, the space may be truncated when no
> longer required by replication or active transactions.
> -->
> Does this mean I could do something else to truncate the log or is it
> saying that the backup log command may truncate the log if it feels
> like it?
> I want ot get a log from a client site onto my server for analysis but
> I want ot make absolute certain that my backing up the log on their
> server won't truncate it there.|||johnbandettini@.yahoo.co.uk wrote:
> Trevor
> A backup of the transaction log will truncate the transaction log. All
> completed transactions will be removed.
> What are you planing to do with the transaction log? There is not a lot
> you can do with out a matching database. As far as I am aware,
> Lumigent's Log reader is the only product that can read the transaction
> log.

Hi John, thanks for the reply.

I do intend to view the log, I'm using SQLLog Rescue from
www.red-gate.com. I can connect to their server over a VPN but it took
hours to read the log and got a general network error during the
process. What I want to do is restore the database on my server c/w
logs so I can view them here.

I know I can grab the data files and attach them on my end but I would
have to wait until tonight when people are off line to free up the
files.|||On 9 Jun 2006 02:35:01 -0700, Trevor Best wrote:

(snip)
>I want ot get a log from a client site onto my server for analysis but
>I want ot make absolute certain that my backing up the log on their
>server won't truncate it there.

Hi Trevor,

BACKUP LOG <databasename>
TO DISK = 'x:\y\z\logbackup.bak'
WITH COPY_ONLY;

--
Hugo Kornelis, SQL Server MVP|||"Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
news:5hmi82pfl02iqnhelegm0v515dbdm1qpid@.4ax.com...
> On 9 Jun 2006 02:35:01 -0700, Trevor Best wrote:
> (snip)
> >I want ot get a log from a client site onto my server for analysis but
> >I want ot make absolute certain that my backing up the log on their
> >server won't truncate it there.
> Hi Trevor,
> BACKUP LOG <databasename>
> TO DISK = 'x:\y\z\logbackup.bak'
> WITH COPY_ONLY;

Is this a SQL 2005 specific command? I've never seen it before.

Very handy.

> --
> Hugo Kornelis, SQL Server MVP|||Greg D. Moore (Strider) (mooregr_deleteth1s@.greenms.com) writes:
> "Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
> news:5hmi82pfl02iqnhelegm0v515dbdm1qpid@.4ax.com...
>> BACKUP LOG <databasename>
>> TO DISK = 'x:\y\z\logbackup.bak'
>> WITH COPY_ONLY;
> Is this a SQL 2005 specific command? I've never seen it before.

Yes, that's a new addition (which I neither I had noticed until Hugo
posted about it). It appears to be a "NO_TRUNCATE light". That is,
NO_TRUNCATE also waives the requirement that the database should be
accessible etc and is mainly intended for emergency situations.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Sat, 10 Jun 2006 12:51:23 +0000 (UTC), Erland Sommarskog wrote:

>Greg D. Moore (Strider) (mooregr_deleteth1s@.greenms.com) writes:
>> "Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
>> news:5hmi82pfl02iqnhelegm0v515dbdm1qpid@.4ax.com...
>>> BACKUP LOG <databasename>
>>> TO DISK = 'x:\y\z\logbackup.bak'
>>> WITH COPY_ONLY;
>>
>> Is this a SQL 2005 specific command? I've never seen it before.
>Yes, that's a new addition (which I neither I had noticed until Hugo
>posted about it). It appears to be a "NO_TRUNCATE light". That is,
>NO_TRUNCATE also waives the requirement that the database should be
>accessible etc and is mainly intended for emergency situations.

Hi Erland,

That's right. The major advantage of COPY_ONLY over NO_TRUNCATE is (IMO)
that this option also works on full and incremental backups. It's a
great way to quickly get a backup of a DB to do some tests or
trouble-shooting on without disrupting the backup schema.

--
Hugo Kornelis, SQL Server MVP|||"Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
news:9juo821f71b7ah782onh5lbotre5qrgie1@.4ax.com...
> On Sat, 10 Jun 2006 12:51:23 +0000 (UTC), Erland Sommarskog wrote:
> >Greg D. Moore (Strider) (mooregr_deleteth1s@.greenms.com) writes:
> >> "Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
> >> news:5hmi82pfl02iqnhelegm0v515dbdm1qpid@.4ax.com...
> >>> BACKUP LOG <databasename>
> >>> TO DISK = 'x:\y\z\logbackup.bak'
> >>> WITH COPY_ONLY;
> >>
> >> Is this a SQL 2005 specific command? I've never seen it before.
> >Yes, that's a new addition (which I neither I had noticed until Hugo
> >posted about it). It appears to be a "NO_TRUNCATE light". That is,
> >NO_TRUNCATE also waives the requirement that the database should be
> >accessible etc and is mainly intended for emergency situations.
> Hi Erland,
> That's right. The major advantage of COPY_ONLY over NO_TRUNCATE is (IMO)
> that this option also works on full and incremental backups. It's a
> great way to quickly get a backup of a DB to do some tests or
> trouble-shooting on without disrupting the backup schema.

Yeah, that's why I was thinking it would be so useful.

I'll have to keep it in mind for when we upgrade to SQL 2005.

(Still have to have THAT particular debate with the finance folks who pay
the bills. :-)

> --
> Hugo Kornelis, SQL Server MVP

Friday, February 10, 2012

backup files not created

I am trying to backup a database and transaction log as part of a maintenance
plan. The job indicates that it runs successfully but the .bak and .trn files
do not get created in the location specified. I tried different drive and
server locations and checked all the permissions. Two other databases in the
same maintenance plan work properly but just this one does not. The log file
within the scheduled job shows the path to the files, but they are not there.
The SQL Server Log says that the database did not get backed up but gives no
specific error message, except to indicate that Backup failed to complete the
command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
Full.Tom,
What happens if you try to backup the database manually via EM or T-SQL?
Does this work? Might provide more details as to the cause of the failure.
HTH
Jerry
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
>I am trying to backup a database and transaction log as part of a
>maintenance
> plan. The job indicates that it runs successfully but the .bak and .trn
> files
> do not get created in the location specified. I tried different drive and
> server locations and checked all the permissions. Two other databases in
> the
> same maintenance plan work properly but just this one does not. The log
> file
> within the scheduled job shows the path to the files, but they are not
> there.
> The SQL Server Log says that the database did not get backed up but gives
> no
> specific error message, except to indicate that Backup failed to complete
> the
> command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
> Full.|||Also make sure you have not selected the 'Attempt to repair any minor
problems' checkbox. Requires the DB to be in single user mode.
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
>I am trying to backup a database and transaction log as part of a
>maintenance
> plan. The job indicates that it runs successfully but the .bak and .trn
> files
> do not get created in the location specified. I tried different drive and
> server locations and checked all the permissions. Two other databases in
> the
> same maintenance plan work properly but just this one does not. The log
> file
> within the scheduled job shows the path to the files, but they are not
> there.
> The SQL Server Log says that the database did not get backed up but gives
> no
> specific error message, except to indicate that Backup failed to complete
> the
> command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
> Full.|||A manual backup (complete) from EM worked today for the database. I
deselected everything under the Options tab. I also did a transaction log
backup successfully through EM. The scheduled job did not complete when I
re-tried it.
On the DB maintenance job, I am only selecting that database and transaction
log and am taking the default location. I don't see any "Attempt to
repair..." settings in the maintenance plan.
Thanks.
"Jerry Spivey" wrote:
> Tom,
> What happens if you try to backup the database manually via EM or T-SQL?
> Does this work? Might provide more details as to the cause of the failure.
> HTH
> Jerry
> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
> >I am trying to backup a database and transaction log as part of a
> >maintenance
> > plan. The job indicates that it runs successfully but the .bak and .trn
> > files
> > do not get created in the location specified. I tried different drive and
> > server locations and checked all the permissions. Two other databases in
> > the
> > same maintenance plan work properly but just this one does not. The log
> > file
> > within the scheduled job shows the path to the files, but they are not
> > there.
> > The SQL Server Log says that the database did not get backed up but gives
> > no
> > specific error message, except to indicate that Backup failed to complete
> > the
> > command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
> > Full.
>
>|||If you specify a report file for the maint job, you should be able to see any error messages in that
generated report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:3DDF43BE-AD8D-4A45-B169-E40050A3474D@.microsoft.com...
>A manual backup (complete) from EM worked today for the database. I
> deselected everything under the Options tab. I also did a transaction log
> backup successfully through EM. The scheduled job did not complete when I
> re-tried it.
> On the DB maintenance job, I am only selecting that database and transaction
> log and am taking the default location. I don't see any "Attempt to
> repair..." settings in the maintenance plan.
> Thanks.
> "Jerry Spivey" wrote:
>> Tom,
>> What happens if you try to backup the database manually via EM or T-SQL?
>> Does this work? Might provide more details as to the cause of the failure.
>> HTH
>> Jerry
>> "TomM" <TomM@.discussions.microsoft.com> wrote in message
>> news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
>> >I am trying to backup a database and transaction log as part of a
>> >maintenance
>> > plan. The job indicates that it runs successfully but the .bak and .trn
>> > files
>> > do not get created in the location specified. I tried different drive and
>> > server locations and checked all the permissions. Two other databases in
>> > the
>> > same maintenance plan work properly but just this one does not. The log
>> > file
>> > within the scheduled job shows the path to the files, but they are not
>> > there.
>> > The SQL Server Log says that the database did not get backed up but gives
>> > no
>> > specific error message, except to indicate that Backup failed to complete
>> > the
>> > command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
>> > Full.
>>|||Tibor,
I did that and it tells me that the job was successful. It even gives me the
name of the file that is supposed to be created. The file isn't there and the
SQL log gives me the same error as previously mentioned.
"Tibor Karaszi" wrote:
> If you specify a report file for the maint job, you should be able to see any error messages in that
> generated report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> news:3DDF43BE-AD8D-4A45-B169-E40050A3474D@.microsoft.com...
> >A manual backup (complete) from EM worked today for the database. I
> > deselected everything under the Options tab. I also did a transaction log
> > backup successfully through EM. The scheduled job did not complete when I
> > re-tried it.
> >
> > On the DB maintenance job, I am only selecting that database and transaction
> > log and am taking the default location. I don't see any "Attempt to
> > repair..." settings in the maintenance plan.
> >
> > Thanks.
> >
> > "Jerry Spivey" wrote:
> >
> >> Tom,
> >>
> >> What happens if you try to backup the database manually via EM or T-SQL?
> >> Does this work? Might provide more details as to the cause of the failure.
> >>
> >> HTH
> >>
> >> Jerry
> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> >> news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
> >> >I am trying to backup a database and transaction log as part of a
> >> >maintenance
> >> > plan. The job indicates that it runs successfully but the .bak and .trn
> >> > files
> >> > do not get created in the location specified. I tried different drive and
> >> > server locations and checked all the permissions. Two other databases in
> >> > the
> >> > same maintenance plan work properly but just this one does not. The log
> >> > file
> >> > within the scheduled job shows the path to the files, but they are not
> >> > there.
> >> > The SQL Server Log says that the database did not get backed up but gives
> >> > no
> >> > specific error message, except to indicate that Backup failed to complete
> >> > the
> >> > command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
> >> > Full.
> >>
> >>
> >>
>|||Strange... Is below correct:
No error in the maint wiz report file.
No backup file.
An error in the eventlog and the same error in the eventlog. Can you post that exact error
message(s)?
Other databases backup OK to the same location.
Is this database bigger than the other database?
Do you backup over a network to an UNC name?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:7E5093F4-DAA2-4F3A-BF23-BF1B929E582E@.microsoft.com...
> Tibor,
> I did that and it tells me that the job was successful. It even gives me the
> name of the file that is supposed to be created. The file isn't there and the
> SQL log gives me the same error as previously mentioned.
> "Tibor Karaszi" wrote:
>> If you specify a report file for the maint job, you should be able to see any error messages in
>> that
>> generated report file.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "TomM" <TomM@.discussions.microsoft.com> wrote in message
>> news:3DDF43BE-AD8D-4A45-B169-E40050A3474D@.microsoft.com...
>> >A manual backup (complete) from EM worked today for the database. I
>> > deselected everything under the Options tab. I also did a transaction log
>> > backup successfully through EM. The scheduled job did not complete when I
>> > re-tried it.
>> >
>> > On the DB maintenance job, I am only selecting that database and transaction
>> > log and am taking the default location. I don't see any "Attempt to
>> > repair..." settings in the maintenance plan.
>> >
>> > Thanks.
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> Tom,
>> >>
>> >> What happens if you try to backup the database manually via EM or T-SQL?
>> >> Does this work? Might provide more details as to the cause of the failure.
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
>> >> news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
>> >> >I am trying to backup a database and transaction log as part of a
>> >> >maintenance
>> >> > plan. The job indicates that it runs successfully but the .bak and .trn
>> >> > files
>> >> > do not get created in the location specified. I tried different drive and
>> >> > server locations and checked all the permissions. Two other databases in
>> >> > the
>> >> > same maintenance plan work properly but just this one does not. The log
>> >> > file
>> >> > within the scheduled job shows the path to the files, but they are not
>> >> > there.
>> >> > The SQL Server Log says that the database did not get backed up but gives
>> >> > no
>> >> > specific error message, except to indicate that Backup failed to complete
>> >> > the
>> >> > command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
>> >> > Full.
>> >>
>> >>
>> >>
>>|||Yes, very strange.
Everything you have listed is accurate. TLog grows rapidly and is now around
5gb, db about 7 GB total, other db's much smaller. I ran dbcc shrinkfile on
log file but db still did not backup. I tried backing up to a remote server
as well as the default location. Manual backup does work. Other dbs backup as
scheduled.
This is error from SQL Log:
BACKUP failed to complete the command BACKUP DATABASE [Kronos_LS] TO DISK =N'e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_LS_db_200509201123.BAK' WITH INIT
, NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
This is from Maint. Plan log:
Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' : Step 1,
'Step 1' : Began Executing 2005-09-20 11:23:40
output
-----------
(null)
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
Copyright (C) Microsoft Corporation, 1995 - 1998
(null)
Logged on to SQL Server 'NAMSDATWN500'
as 'sa' (non-trusted)
(null)
Starting maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:40 AM
(null)
[1] Database Kronos_LS: Database Backup...
(null)
Destination:
[e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_LS_db_200509201123.BAK]
(null)
(null)
** Execution Time: 0 hrs, 0 mins, 8 secs **
(null)
(null)
End of maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:48 AM
(null)
SQLMAINT.EXE Process Exit Code: 0 (Success)
(null)
"Tibor Karaszi" wrote:
> Strange... Is below correct:
> No error in the maint wiz report file.
> No backup file.
> An error in the eventlog and the same error in the eventlog. Can you post that exact error
> message(s)?
> Other databases backup OK to the same location.
> Is this database bigger than the other database?
> Do you backup over a network to an UNC name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> news:7E5093F4-DAA2-4F3A-BF23-BF1B929E582E@.microsoft.com...
> > Tibor,
> >
> > I did that and it tells me that the job was successful. It even gives me the
> > name of the file that is supposed to be created. The file isn't there and the
> > SQL log gives me the same error as previously mentioned.
> >
> > "Tibor Karaszi" wrote:
> >
> >> If you specify a report file for the maint job, you should be able to see any error messages in
> >> that
> >> generated report file.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> >> news:3DDF43BE-AD8D-4A45-B169-E40050A3474D@.microsoft.com...
> >> >A manual backup (complete) from EM worked today for the database. I
> >> > deselected everything under the Options tab. I also did a transaction log
> >> > backup successfully through EM. The scheduled job did not complete when I
> >> > re-tried it.
> >> >
> >> > On the DB maintenance job, I am only selecting that database and transaction
> >> > log and am taking the default location. I don't see any "Attempt to
> >> > repair..." settings in the maintenance plan.
> >> >
> >> > Thanks.
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> Tom,
> >> >>
> >> >> What happens if you try to backup the database manually via EM or T-SQL?
> >> >> Does this work? Might provide more details as to the cause of the failure.
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> >> >> news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
> >> >> >I am trying to backup a database and transaction log as part of a
> >> >> >maintenance
> >> >> > plan. The job indicates that it runs successfully but the .bak and .trn
> >> >> > files
> >> >> > do not get created in the location specified. I tried different drive and
> >> >> > server locations and checked all the permissions. Two other databases in
> >> >> > the
> >> >> > same maintenance plan work properly but just this one does not. The log
> >> >> > file
> >> >> > within the scheduled job shows the path to the files, but they are not
> >> >> > there.
> >> >> > The SQL Server Log says that the database did not get backed up but gives
> >> >> > no
> >> >> > specific error message, except to indicate that Backup failed to complete
> >> >> > the
> >> >> > command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
> >> >> > Full.
> >> >>
> >> >>
> >> >>
> >>
> >>
>|||I'm sorry, but I'm out of ideas. Unless someone else jumps in here, you might want to open a case
with MS Support...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:FFCE3E14-E2A3-4D40-A27C-335E99FFF4A8@.microsoft.com...
> Yes, very strange.
> Everything you have listed is accurate. TLog grows rapidly and is now around
> 5gb, db about 7 GB total, other db's much smaller. I ran dbcc shrinkfile on
> log file but db still did not backup. I tried backing up to a remote server
> as well as the default location. Manual backup does work. Other dbs backup as
> scheduled.
> This is error from SQL Log:
> BACKUP failed to complete the command BACKUP DATABASE [Kronos_LS] TO DISK => N'e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_LS_db_200509201123.BAK' WITH INIT
> , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> This is from Maint. Plan log:
> Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' : Step 1,
> 'Step 1' : Began Executing 2005-09-20 11:23:40
> output
>
> -----------
> (null)
> Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
>
> Copyright (C) Microsoft Corporation, 1995 - 1998
>
> (null)
> Logged on to SQL Server 'NAMSDATWN500'
>
> as 'sa' (non-trusted)
>
> (null)
> Starting maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:40 AM
>
> (null)
> [1] Database Kronos_LS: Database Backup...
>
> (null)
> Destination:
> [e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_LS_db_200509201123.BAK]
>
> (null)
> (null)
> ** Execution Time: 0 hrs, 0 mins, 8 secs **
>
> (null)
> (null)
> End of maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:48 AM
>
> (null)
> SQLMAINT.EXE Process Exit Code: 0 (Success)
>
> (null)
>
> "Tibor Karaszi" wrote:
>> Strange... Is below correct:
>> No error in the maint wiz report file.
>> No backup file.
>> An error in the eventlog and the same error in the eventlog. Can you post that exact error
>> message(s)?
>> Other databases backup OK to the same location.
>> Is this database bigger than the other database?
>> Do you backup over a network to an UNC name?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "TomM" <TomM@.discussions.microsoft.com> wrote in message
>> news:7E5093F4-DAA2-4F3A-BF23-BF1B929E582E@.microsoft.com...
>> > Tibor,
>> >
>> > I did that and it tells me that the job was successful. It even gives me the
>> > name of the file that is supposed to be created. The file isn't there and the
>> > SQL log gives me the same error as previously mentioned.
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> If you specify a report file for the maint job, you should be able to see any error messages
>> >> in
>> >> that
>> >> generated report file.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >> Blog: http://solidqualitylearning.com/blogs/tibor/
>> >>
>> >>
>> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
>> >> news:3DDF43BE-AD8D-4A45-B169-E40050A3474D@.microsoft.com...
>> >> >A manual backup (complete) from EM worked today for the database. I
>> >> > deselected everything under the Options tab. I also did a transaction log
>> >> > backup successfully through EM. The scheduled job did not complete when I
>> >> > re-tried it.
>> >> >
>> >> > On the DB maintenance job, I am only selecting that database and transaction
>> >> > log and am taking the default location. I don't see any "Attempt to
>> >> > repair..." settings in the maintenance plan.
>> >> >
>> >> > Thanks.
>> >> >
>> >> > "Jerry Spivey" wrote:
>> >> >
>> >> >> Tom,
>> >> >>
>> >> >> What happens if you try to backup the database manually via EM or T-SQL?
>> >> >> Does this work? Might provide more details as to the cause of the failure.
>> >> >>
>> >> >> HTH
>> >> >>
>> >> >> Jerry
>> >> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
>> >> >> news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
>> >> >> >I am trying to backup a database and transaction log as part of a
>> >> >> >maintenance
>> >> >> > plan. The job indicates that it runs successfully but the .bak and .trn
>> >> >> > files
>> >> >> > do not get created in the location specified. I tried different drive and
>> >> >> > server locations and checked all the permissions. Two other databases in
>> >> >> > the
>> >> >> > same maintenance plan work properly but just this one does not. The log
>> >> >> > file
>> >> >> > within the scheduled job shows the path to the files, but they are not
>> >> >> > there.
>> >> >> > The SQL Server Log says that the database did not get backed up but gives
>> >> >> > no
>> >> >> > specific error message, except to indicate that Backup failed to complete
>> >> >> > the
>> >> >> > command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
>> >> >> > Full.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>|||Thanks for trying.
"Tibor Karaszi" wrote:
> I'm sorry, but I'm out of ideas. Unless someone else jumps in here, you might want to open a case
> with MS Support...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> news:FFCE3E14-E2A3-4D40-A27C-335E99FFF4A8@.microsoft.com...
> > Yes, very strange.
> > Everything you have listed is accurate. TLog grows rapidly and is now around
> > 5gb, db about 7 GB total, other db's much smaller. I ran dbcc shrinkfile on
> > log file but db still did not backup. I tried backing up to a remote server
> > as well as the default location. Manual backup does work. Other dbs backup as
> > scheduled.
> >
> > This is error from SQL Log:
> > BACKUP failed to complete the command BACKUP DATABASE [Kronos_LS] TO DISK => > N'e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_LS_db_200509201123.BAK' WITH INIT
> > , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> >
> > This is from Maint. Plan log:
> > Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' : Step 1,
> > 'Step 1' : Began Executing 2005-09-20 11:23:40
> >
> > output
> >
> >
> >
> > -----------
> > (null)
> > Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
> >
> >
> >
> > Copyright (C) Microsoft Corporation, 1995 - 1998
> >
> >
> >
> > (null)
> > Logged on to SQL Server 'NAMSDATWN500'
> >
> >
> >
> > as 'sa' (non-trusted)
> >
> >
> >
> > (null)
> > Starting maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:40 AM
> >
> >
> >
> > (null)
> > [1] Database Kronos_LS: Database Backup...
> >
> >
> >
> > (null)
> > Destination:
> > [e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_LS_db_200509201123.BAK]
> >
> >
> >
> > (null)
> > (null)
> > ** Execution Time: 0 hrs, 0 mins, 8 secs **
> >
> >
> >
> > (null)
> > (null)
> > End of maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:48 AM
> >
> >
> >
> > (null)
> > SQLMAINT.EXE Process Exit Code: 0 (Success)
> >
> >
> >
> > (null)
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> Strange... Is below correct:
> >> No error in the maint wiz report file.
> >> No backup file.
> >> An error in the eventlog and the same error in the eventlog. Can you post that exact error
> >> message(s)?
> >> Other databases backup OK to the same location.
> >> Is this database bigger than the other database?
> >> Do you backup over a network to an UNC name?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> >> news:7E5093F4-DAA2-4F3A-BF23-BF1B929E582E@.microsoft.com...
> >> > Tibor,
> >> >
> >> > I did that and it tells me that the job was successful. It even gives me the
> >> > name of the file that is supposed to be created. The file isn't there and the
> >> > SQL log gives me the same error as previously mentioned.
> >> >
> >> > "Tibor Karaszi" wrote:
> >> >
> >> >> If you specify a report file for the maint job, you should be able to see any error messages
> >> >> in
> >> >> that
> >> >> generated report file.
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >> >>
> >> >>
> >> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> >> >> news:3DDF43BE-AD8D-4A45-B169-E40050A3474D@.microsoft.com...
> >> >> >A manual backup (complete) from EM worked today for the database. I
> >> >> > deselected everything under the Options tab. I also did a transaction log
> >> >> > backup successfully through EM. The scheduled job did not complete when I
> >> >> > re-tried it.
> >> >> >
> >> >> > On the DB maintenance job, I am only selecting that database and transaction
> >> >> > log and am taking the default location. I don't see any "Attempt to
> >> >> > repair..." settings in the maintenance plan.
> >> >> >
> >> >> > Thanks.
> >> >> >
> >> >> > "Jerry Spivey" wrote:
> >> >> >
> >> >> >> Tom,
> >> >> >>
> >> >> >> What happens if you try to backup the database manually via EM or T-SQL?
> >> >> >> Does this work? Might provide more details as to the cause of the failure.
> >> >> >>
> >> >> >> HTH
> >> >> >>
> >> >> >> Jerry
> >> >> >> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> >> >> >> news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
> >> >> >> >I am trying to backup a database and transaction log as part of a
> >> >> >> >maintenance
> >> >> >> > plan. The job indicates that it runs successfully but the .bak and .trn
> >> >> >> > files
> >> >> >> > do not get created in the location specified. I tried different drive and
> >> >> >> > server locations and checked all the permissions. Two other databases in
> >> >> >> > the
> >> >> >> > same maintenance plan work properly but just this one does not. The log
> >> >> >> > file
> >> >> >> > within the scheduled job shows the path to the files, but they are not
> >> >> >> > there.
> >> >> >> > The SQL Server Log says that the database did not get backed up but gives
> >> >> >> > no
> >> >> >> > specific error message, except to indicate that Backup failed to complete
> >> >> >> > the
> >> >> >> > command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
> >> >> >> > Full.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>

Sunday, March 11, 2012

Backup Problem - multiple family members

backup problem

Backup problem

Friday, February 24, 2012

Backup MSDE with NetBackup?

Thursday, February 16, 2012

Backup log - will it truncate?

Friday, February 10, 2012

backup files not created

backup files not created

backup files not created

sql backup files

Blog Archive

About Me