Hi Everyone,
I've got Windows SharePoint Services installed and it uses a database called
STS_svr-apps-1_1414639615
I'm trying to back up this database from the QSQL command line tool.
However when I try to run the backup, I get the following error:
1> BACKUP DATABASE STS_svr-apps-1_1414639615 TO DISK
'D:\ShareBack\Backup.bak'
2> GO
Msg 170, Level 15, State 1, Server SVR-APPS-1\SHAREPOINT, Line 1
Line 1: Incorrect syntax near '-'.
1>
Thinking it might be an issue with the name I enclosed it in single quotes:
1> BACKUP DATABASE 'STS_svr-apps-1_1414639615' TO DISK
'D:\ShareBack\Backup.bak'
2> GO
Msg 170, Level 15, State 1, Server SVR-APPS-1\SHAREPOINT, Line 1
Line 1: Incorrect syntax near 'STS_svr-apps-1_1414639615'.
1>
Yet I still get the same error!
Then I tried to just use the database:
1> use STS_svr-apps-1_1414639615
2> go
Msg 911, Level 16, State 1, Server SVR-APPS-1\SHAREPOINT, Line 1
Could not locate entry in sysdatabases for database 'STS_svr'. No entry
found
with that name. Make sure that the name is entered correctly.
1>
Again I tried to using quotation marks, another error:
1> use 'STS_svr-apps-1_1414639615'
2> GO
Msg 170, Level 15, State 1, Server SVR-APPS-1\SHAREPOINT, Line 1
Line 1: Incorrect syntax near 'STS_svr-apps-1_1414639615'.
1> quit
If I do:
SELECT name
FROM master..sysdatabases
ORDER BY name
It lists:
master
model
msdb
STS_Config
STS_svr-apps-1_1414639615
tempdb
From this I can only assume MSDE doesn't support having '-' in a database
name?
Can someone suggest a way around this?
Thanks
Chris Moon
hi Chris,
> From this I can only assume MSDE doesn't support having '-' in a
> database name?
>
SQL Server (and MSDE) support this kind of identifier.. executing
SET NOCOUNT ON
SELECT @.@.VERSION
GO
CREATE DATABASE [STS_svr-apps-1_1414639615];
GO
USE [STS_svr-apps-1_1414639615];
GO
USE master ;
GO
DROP DATABASE [STS_svr-apps-1_1414639615];
reports
Microsoft SQL Server 2000 - 8.00.2162 (Intel X86)
Sep 30 2005 19:59:14
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
The CREATE DATABASE process is allocating 0.75 MB on disk
'STS_svr-apps-1_1414639615'.
The CREATE DATABASE process is allocating 0.49 MB on disk
'STS_svr-apps-1_1414639615_log'.
Deleting database file 'C:\Programmi\Microsoft SQL
Server\MSSQL$MSDE2K\Data\STS_svr-apps-1_1414639615_log.LDF'.
Deleting database file 'C:\Programmi\Microsoft SQL
Server\MSSQL$MSDE2K\Data\STS_svr-apps-1_1414639615.mdf'.
http://msdn.microsoft.com/library/de...on_03_6e9e.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Many thanks Andrea, it worked perfectly.
Thanks again.
Chris Moon
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:43ml8mF1o772rU1@.individual.net...
> hi Chris,
> SQL Server (and MSDE) support this kind of identifier.. executing
> SET NOCOUNT ON
> SELECT @.@.VERSION
> GO
> CREATE DATABASE [STS_svr-apps-1_1414639615];
> GO
> USE [STS_svr-apps-1_1414639615];
> GO
> USE master ;
> GO
> DROP DATABASE [STS_svr-apps-1_1414639615];
> reports
> ----
> Microsoft SQL Server 2000 - 8.00.2162 (Intel X86)
> Sep 30 2005 19:59:14
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
> The CREATE DATABASE process is allocating 0.75 MB on disk
> 'STS_svr-apps-1_1414639615'.
> The CREATE DATABASE process is allocating 0.49 MB on disk
> 'STS_svr-apps-1_1414639615_log'.
> Deleting database file 'C:\Programmi\Microsoft SQL
> Server\MSSQL$MSDE2K\Data\STS_svr-apps-1_1414639615_log.LDF'.
> Deleting database file 'C:\Programmi\Microsoft SQL
> Server\MSSQL$MSDE2K\Data\STS_svr-apps-1_1414639615.mdf'.
> http://msdn.microsoft.com/library/de...on_03_6e9e.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql
Showing posts with label back. Show all posts
Showing posts with label back. Show all posts
Thursday, March 29, 2012
Sunday, March 11, 2012
Database maintenance plan: .trn file not backed up
We have installed an SQL 2000 database over a Windows 2000
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" module
See my reply to your post int he other group. Please don't multipost.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module
|||Do not use the daily plan but use the weekly and tick all seven days if need be. For some reason 'Daily' is not quite what it seems, as it is more of a 'one off' than a schedule.
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" module
See my reply to your post int he other group. Please don't multipost.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module
|||Do not use the daily plan but use the weekly and tick all seven days if need be. For some reason 'Daily' is not quite what it seems, as it is more of a 'one off' than a schedule.
Database maintenance plan: .trn file not backed up
We have installed an SQL 2000 database over a Windows 2000
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" moduleSee my reply to your post int he other group. Please don't multipost.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module|||Do not use the daily plan but use the weekly and tick all seven days if need
be. For some reason 'Daily' is not quite what it seems, as it is more of a
'one off' than a schedule.
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" moduleSee my reply to your post int he other group. Please don't multipost.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module|||Do not use the daily plan but use the weekly and tick all seven days if need
be. For some reason 'Daily' is not quite what it seems, as it is more of a
'one off' than a schedule.
Database maintenance plan: .trn file not backed up
We have installed an SQL 2000 database over a Windows 2000
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" moduleSee my reply to your post int he other group. Please don't multipost.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" moduleSee my reply to your post int he other group. Please don't multipost.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module
Thursday, March 8, 2012
Database maintenance plan backup
I've created a database maintenance plan with backup database task which is
set to back up the transaction logs of several specified databases. I open
up the backup database task, then choose <select one or more> from the
Database(s) prompt. When the drop down window opens, I select the radio box
for "these databases", and I check the databases that I want. I save the
database maintenance plan and run it and it works fine. If I open up the
backup database task again, and go to see what databases I have selected,
none are showing as selected. If I save the database maintenance plan and
run it, it fails with the following message, which does not tell me much:
Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete End Progress DTExec: The package execution returned
DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
1.437 seconds. The package execution failed. The step failed.
This message contrasts with the text file report that shows:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
Report was generated on "pdcnt23".
Maintenance Plan: MaintenancePlan
Duration: 00:00:00
Status: Succeeded.
Details:
If I go back into the backup task and reselect the databases and save the
maintenance plan and run it, everything works fine.
This doesn't work as I would expect it to. Is there something I need to do?
Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
Thanks,
Paul
Paul,
Losing the database is a known problem. MS is looking into it for a later
build of SQL2005.
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> I've created a database maintenance plan with backup database task which
> is
> set to back up the transaction logs of several specified databases. I
> open
> up the backup database task, then choose <select one or more> from the
> Database(s) prompt. When the drop down window opens, I select the radio
> box
> for "these databases", and I check the databases that I want. I save the
> database maintenance plan and run it and it works fine. If I open up the
> backup database task again, and go to see what databases I have selected,
> none are showing as selected. If I save the database maintenance plan and
> run it, it fails with the following message, which does not tell me much:
> Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete End Progress DTExec: The package execution returned
> DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> 1.437 seconds. The package execution failed. The step failed.
> This message contrasts with the text file report that shows:
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> Report was generated on "pdcnt23".
> Maintenance Plan: MaintenancePlan
> Duration: 00:00:00
> Status: Succeeded.
> Details:
> If I go back into the backup task and reselect the databases and save the
> maintenance plan and run it, everything works fine.
> This doesn't work as I would expect it to. Is there something I need to
> do?
> Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> Thanks,
> Paul
>
|||Thanks Chris.
I had a look around to try and find information about it. Where would I
find more information about it?
Thanks,
Paul
"Chris Wood" wrote:
> Paul,
> Losing the database is a known problem. MS is looking into it for a later
> build of SQL2005.
> Chris
> "PT" <PT@.discussions.microsoft.com> wrote in message
> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
>
>
|||Paul,
Signon to Microsoft Connect:- https://connect.microsoft.com/default.aspx and
register for SQL
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:4C86DAAF-11E8-4CA7-B740-A3CF4BF32C69@.microsoft.com...[vbcol=seagreen]
> Thanks Chris.
> I had a look around to try and find information about it. Where would I
> find more information about it?
> Thanks,
> Paul
> "Chris Wood" wrote:
set to back up the transaction logs of several specified databases. I open
up the backup database task, then choose <select one or more> from the
Database(s) prompt. When the drop down window opens, I select the radio box
for "these databases", and I check the databases that I want. I save the
database maintenance plan and run it and it works fine. If I open up the
backup database task again, and go to see what databases I have selected,
none are showing as selected. If I save the database maintenance plan and
run it, it fails with the following message, which does not tell me much:
Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete End Progress DTExec: The package execution returned
DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
1.437 seconds. The package execution failed. The step failed.
This message contrasts with the text file report that shows:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
Report was generated on "pdcnt23".
Maintenance Plan: MaintenancePlan
Duration: 00:00:00
Status: Succeeded.
Details:
If I go back into the backup task and reselect the databases and save the
maintenance plan and run it, everything works fine.
This doesn't work as I would expect it to. Is there something I need to do?
Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
Thanks,
Paul
Paul,
Losing the database is a known problem. MS is looking into it for a later
build of SQL2005.
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> I've created a database maintenance plan with backup database task which
> is
> set to back up the transaction logs of several specified databases. I
> open
> up the backup database task, then choose <select one or more> from the
> Database(s) prompt. When the drop down window opens, I select the radio
> box
> for "these databases", and I check the databases that I want. I save the
> database maintenance plan and run it and it works fine. If I open up the
> backup database task again, and go to see what databases I have selected,
> none are showing as selected. If I save the database maintenance plan and
> run it, it fails with the following message, which does not tell me much:
> Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete End Progress DTExec: The package execution returned
> DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> 1.437 seconds. The package execution failed. The step failed.
> This message contrasts with the text file report that shows:
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> Report was generated on "pdcnt23".
> Maintenance Plan: MaintenancePlan
> Duration: 00:00:00
> Status: Succeeded.
> Details:
> If I go back into the backup task and reselect the databases and save the
> maintenance plan and run it, everything works fine.
> This doesn't work as I would expect it to. Is there something I need to
> do?
> Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> Thanks,
> Paul
>
|||Thanks Chris.
I had a look around to try and find information about it. Where would I
find more information about it?
Thanks,
Paul
"Chris Wood" wrote:
> Paul,
> Losing the database is a known problem. MS is looking into it for a later
> build of SQL2005.
> Chris
> "PT" <PT@.discussions.microsoft.com> wrote in message
> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
>
>
|||Paul,
Signon to Microsoft Connect:- https://connect.microsoft.com/default.aspx and
register for SQL
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:4C86DAAF-11E8-4CA7-B740-A3CF4BF32C69@.microsoft.com...[vbcol=seagreen]
> Thanks Chris.
> I had a look around to try and find information about it. Where would I
> find more information about it?
> Thanks,
> Paul
> "Chris Wood" wrote:
Database maintenance plan backup
I've created a database maintenance plan with backup database task which is
set to back up the transaction logs of several specified databases. I open
up the backup database task, then choose <select one or more> from the
Database(s) prompt. When the drop down window opens, I select the radio box
for "these databases", and I check the databases that I want. I save the
database maintenance plan and run it and it works fine. If I open up the
backup database task again, and go to see what databases I have selected,
none are showing as selected. If I save the database maintenance plan and
run it, it fails with the following message, which does not tell me much:
Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete End Progress DTExec: The package execution returned
DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
1.437 seconds. The package execution failed. The step failed.
This message contrasts with the text file report that shows:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
Report was generated on "pdcnt23".
Maintenance Plan: MaintenancePlan
Duration: 00:00:00
Status: Succeeded.
Details:
If I go back into the backup task and reselect the databases and save the
maintenance plan and run it, everything works fine.
This doesn't work as I would expect it to. Is there something I need to do?
Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
Thanks,
PaulPaul,
Losing the database is a known problem. MS is looking into it for a later
build of SQL2005.
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> I've created a database maintenance plan with backup database task which
> is
> set to back up the transaction logs of several specified databases. I
> open
> up the backup database task, then choose <select one or more> from the
> Database(s) prompt. When the drop down window opens, I select the radio
> box
> for "these databases", and I check the databases that I want. I save the
> database maintenance plan and run it and it works fine. If I open up the
> backup database task again, and go to see what databases I have selected,
> none are showing as selected. If I save the database maintenance plan and
> run it, it fails with the following message, which does not tell me much:
> Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete End Progress DTExec: The package execution returned
> DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> 1.437 seconds. The package execution failed. The step failed.
> This message contrasts with the text file report that shows:
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> Report was generated on "pdcnt23".
> Maintenance Plan: MaintenancePlan
> Duration: 00:00:00
> Status: Succeeded.
> Details:
> If I go back into the backup task and reselect the databases and save the
> maintenance plan and run it, everything works fine.
> This doesn't work as I would expect it to. Is there something I need to
> do?
> Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> Thanks,
> Paul
>|||Thanks Chris.
I had a look around to try and find information about it. Where would I
find more information about it?
Thanks,
Paul
"Chris Wood" wrote:
> Paul,
> Losing the database is a known problem. MS is looking into it for a later
> build of SQL2005.
> Chris
> "PT" <PT@.discussions.microsoft.com> wrote in message
> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> > I've created a database maintenance plan with backup database task which
> > is
> > set to back up the transaction logs of several specified databases. I
> > open
> > up the backup database task, then choose <select one or more> from the
> > Database(s) prompt. When the drop down window opens, I select the radio
> > box
> > for "these databases", and I check the databases that I want. I save the
> > database maintenance plan and run it and it works fine. If I open up the
> > backup database task again, and go to see what databases I have selected,
> > none are showing as selected. If I save the database maintenance plan and
> > run it, it fails with the following message, which does not tell me much:
> >
> > Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> > Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> > Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> > 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
> > Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> > 100% complete End Progress DTExec: The package execution returned
> > DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> > 1.437 seconds. The package execution failed. The step failed.
> >
> > This message contrasts with the text file report that shows:
> >
> > NEW COMPONENT OUTPUT
> > Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> > Report was generated on "pdcnt23".
> > Maintenance Plan: MaintenancePlan
> > Duration: 00:00:00
> > Status: Succeeded.
> > Details:
> >
> > If I go back into the backup task and reselect the databases and save the
> > maintenance plan and run it, everything works fine.
> >
> > This doesn't work as I would expect it to. Is there something I need to
> > do?
> >
> > Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> >
> > Thanks,
> >
> > Paul
> >
>
>|||Paul,
Signon to Microsoft Connect:- https://connect.microsoft.com/default.aspx and
register for SQL
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:4C86DAAF-11E8-4CA7-B740-A3CF4BF32C69@.microsoft.com...
> Thanks Chris.
> I had a look around to try and find information about it. Where would I
> find more information about it?
> Thanks,
> Paul
> "Chris Wood" wrote:
>> Paul,
>> Losing the database is a known problem. MS is looking into it for a later
>> build of SQL2005.
>> Chris
>> "PT" <PT@.discussions.microsoft.com> wrote in message
>> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
>> > I've created a database maintenance plan with backup database task
>> > which
>> > is
>> > set to back up the transaction logs of several specified databases. I
>> > open
>> > up the backup database task, then choose <select one or more> from the
>> > Database(s) prompt. When the drop down window opens, I select the radio
>> > box
>> > for "these databases", and I check the databases that I want. I save
>> > the
>> > database maintenance plan and run it and it works fine. If I open up
>> > the
>> > backup database task again, and go to see what databases I have
>> > selected,
>> > none are showing as selected. If I save the database maintenance plan
>> > and
>> > run it, it fails with the following message, which does not tell me
>> > much:
>> >
>> > Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server
>> > Execute
>> > Package Utility Version 9.00.3042.00 for 32-bit Copyright (C)
>> > Microsoft
>> > Corp 1984-2005. All rights reserved. Started: 10:58:14 AM
>> > Progress:
>> > 2007-11-16 10:58:15.67 Source:
>> > {0EDA7F25-ED67-4796-9399-668FB2506E5F}
>> > Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE
>> > msdb..sp".:
>> > 100% complete End Progress DTExec: The package execution returned
>> > DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM
>> > Elapsed:
>> > 1.437 seconds. The package execution failed. The step failed.
>> >
>> > This message contrasts with the text file report that shows:
>> >
>> > NEW COMPONENT OUTPUT
>> > Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
>> > Report was generated on "pdcnt23".
>> > Maintenance Plan: MaintenancePlan
>> > Duration: 00:00:00
>> > Status: Succeeded.
>> > Details:
>> >
>> > If I go back into the backup task and reselect the databases and save
>> > the
>> > maintenance plan and run it, everything works fine.
>> >
>> > This doesn't work as I would expect it to. Is there something I need
>> > to
>> > do?
>> >
>> > Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
>> >
>> > Thanks,
>> >
>> > Paul
>> >
>>
set to back up the transaction logs of several specified databases. I open
up the backup database task, then choose <select one or more> from the
Database(s) prompt. When the drop down window opens, I select the radio box
for "these databases", and I check the databases that I want. I save the
database maintenance plan and run it and it works fine. If I open up the
backup database task again, and go to see what databases I have selected,
none are showing as selected. If I save the database maintenance plan and
run it, it fails with the following message, which does not tell me much:
Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete End Progress DTExec: The package execution returned
DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
1.437 seconds. The package execution failed. The step failed.
This message contrasts with the text file report that shows:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
Report was generated on "pdcnt23".
Maintenance Plan: MaintenancePlan
Duration: 00:00:00
Status: Succeeded.
Details:
If I go back into the backup task and reselect the databases and save the
maintenance plan and run it, everything works fine.
This doesn't work as I would expect it to. Is there something I need to do?
Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
Thanks,
PaulPaul,
Losing the database is a known problem. MS is looking into it for a later
build of SQL2005.
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> I've created a database maintenance plan with backup database task which
> is
> set to back up the transaction logs of several specified databases. I
> open
> up the backup database task, then choose <select one or more> from the
> Database(s) prompt. When the drop down window opens, I select the radio
> box
> for "these databases", and I check the databases that I want. I save the
> database maintenance plan and run it and it works fine. If I open up the
> backup database task again, and go to see what databases I have selected,
> none are showing as selected. If I save the database maintenance plan and
> run it, it fails with the following message, which does not tell me much:
> Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete End Progress DTExec: The package execution returned
> DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> 1.437 seconds. The package execution failed. The step failed.
> This message contrasts with the text file report that shows:
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> Report was generated on "pdcnt23".
> Maintenance Plan: MaintenancePlan
> Duration: 00:00:00
> Status: Succeeded.
> Details:
> If I go back into the backup task and reselect the databases and save the
> maintenance plan and run it, everything works fine.
> This doesn't work as I would expect it to. Is there something I need to
> do?
> Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> Thanks,
> Paul
>|||Thanks Chris.
I had a look around to try and find information about it. Where would I
find more information about it?
Thanks,
Paul
"Chris Wood" wrote:
> Paul,
> Losing the database is a known problem. MS is looking into it for a later
> build of SQL2005.
> Chris
> "PT" <PT@.discussions.microsoft.com> wrote in message
> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> > I've created a database maintenance plan with backup database task which
> > is
> > set to back up the transaction logs of several specified databases. I
> > open
> > up the backup database task, then choose <select one or more> from the
> > Database(s) prompt. When the drop down window opens, I select the radio
> > box
> > for "these databases", and I check the databases that I want. I save the
> > database maintenance plan and run it and it works fine. If I open up the
> > backup database task again, and go to see what databases I have selected,
> > none are showing as selected. If I save the database maintenance plan and
> > run it, it fails with the following message, which does not tell me much:
> >
> > Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> > Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> > Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> > 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
> > Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> > 100% complete End Progress DTExec: The package execution returned
> > DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> > 1.437 seconds. The package execution failed. The step failed.
> >
> > This message contrasts with the text file report that shows:
> >
> > NEW COMPONENT OUTPUT
> > Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> > Report was generated on "pdcnt23".
> > Maintenance Plan: MaintenancePlan
> > Duration: 00:00:00
> > Status: Succeeded.
> > Details:
> >
> > If I go back into the backup task and reselect the databases and save the
> > maintenance plan and run it, everything works fine.
> >
> > This doesn't work as I would expect it to. Is there something I need to
> > do?
> >
> > Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> >
> > Thanks,
> >
> > Paul
> >
>
>|||Paul,
Signon to Microsoft Connect:- https://connect.microsoft.com/default.aspx and
register for SQL
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:4C86DAAF-11E8-4CA7-B740-A3CF4BF32C69@.microsoft.com...
> Thanks Chris.
> I had a look around to try and find information about it. Where would I
> find more information about it?
> Thanks,
> Paul
> "Chris Wood" wrote:
>> Paul,
>> Losing the database is a known problem. MS is looking into it for a later
>> build of SQL2005.
>> Chris
>> "PT" <PT@.discussions.microsoft.com> wrote in message
>> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
>> > I've created a database maintenance plan with backup database task
>> > which
>> > is
>> > set to back up the transaction logs of several specified databases. I
>> > open
>> > up the backup database task, then choose <select one or more> from the
>> > Database(s) prompt. When the drop down window opens, I select the radio
>> > box
>> > for "these databases", and I check the databases that I want. I save
>> > the
>> > database maintenance plan and run it and it works fine. If I open up
>> > the
>> > backup database task again, and go to see what databases I have
>> > selected,
>> > none are showing as selected. If I save the database maintenance plan
>> > and
>> > run it, it fails with the following message, which does not tell me
>> > much:
>> >
>> > Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server
>> > Execute
>> > Package Utility Version 9.00.3042.00 for 32-bit Copyright (C)
>> > Microsoft
>> > Corp 1984-2005. All rights reserved. Started: 10:58:14 AM
>> > Progress:
>> > 2007-11-16 10:58:15.67 Source:
>> > {0EDA7F25-ED67-4796-9399-668FB2506E5F}
>> > Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE
>> > msdb..sp".:
>> > 100% complete End Progress DTExec: The package execution returned
>> > DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM
>> > Elapsed:
>> > 1.437 seconds. The package execution failed. The step failed.
>> >
>> > This message contrasts with the text file report that shows:
>> >
>> > NEW COMPONENT OUTPUT
>> > Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
>> > Report was generated on "pdcnt23".
>> > Maintenance Plan: MaintenancePlan
>> > Duration: 00:00:00
>> > Status: Succeeded.
>> > Details:
>> >
>> > If I go back into the backup task and reselect the databases and save
>> > the
>> > maintenance plan and run it, everything works fine.
>> >
>> > This doesn't work as I would expect it to. Is there something I need
>> > to
>> > do?
>> >
>> > Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
>> >
>> > Thanks,
>> >
>> > Paul
>> >
>>
Database maintenance plan backup
I've created a database maintenance plan with backup database task which is
set to back up the transaction logs of several specified databases. I open
up the backup database task, then choose <select one or more> from the
Database(s) prompt. When the drop down window opens, I select the radio box
for "these databases", and I check the databases that I want. I save the
database maintenance plan and run it and it works fine. If I open up the
backup database task again, and go to see what databases I have selected,
none are showing as selected. If I save the database maintenance plan and
run it, it fails with the following message, which does not tell me much:
Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5
F}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete End Progress DTExec: The package execution returned
DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
1.437 seconds. The package execution failed. The step failed.
This message contrasts with the text file report that shows:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
Report was generated on "pdcnt23".
Maintenance Plan: MaintenancePlan
Duration: 00:00:00
Status: Succeeded.
Details:
If I go back into the backup task and reselect the databases and save the
maintenance plan and run it, everything works fine.
This doesn't work as I would expect it to. Is there something I need to do?
Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
Thanks,
PaulPaul,
Losing the database is a known problem. MS is looking into it for a later
build of SQL2005.
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> I've created a database maintenance plan with backup database task which
> is
> set to back up the transaction logs of several specified databases. I
> open
> up the backup database task, then choose <select one or more> from the
> Database(s) prompt. When the drop down window opens, I select the radio
> box
> for "these databases", and I check the databases that I want. I save the
> database maintenance plan and run it and it works fine. If I open up the
> backup database task again, and go to see what databases I have selected,
> none are showing as selected. If I save the database maintenance plan and
> run it, it fails with the following message, which does not tell me much:
> Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506
E5F}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete End Progress DTExec: The package execution returned
> DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> 1.437 seconds. The package execution failed. The step failed.
> This message contrasts with the text file report that shows:
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> Report was generated on "pdcnt23".
> Maintenance Plan: MaintenancePlan
> Duration: 00:00:00
> Status: Succeeded.
> Details:
> If I go back into the backup task and reselect the databases and save the
> maintenance plan and run it, everything works fine.
> This doesn't work as I would expect it to. Is there something I need to
> do?
> Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> Thanks,
> Paul
>|||Thanks Chris.
I had a look around to try and find information about it. Where would I
find more information about it?
Thanks,
Paul
"Chris Wood" wrote:
> Paul,
> Losing the database is a known problem. MS is looking into it for a later
> build of SQL2005.
> Chris
> "PT" <PT@.discussions.microsoft.com> wrote in message
> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
>
>|||Paul,
Signon to Microsoft Connect:- https://connect.microsoft.com/default.aspx and
register for SQL
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:4C86DAAF-11E8-4CA7-B740-A3CF4BF32C69@.microsoft.com...[vbcol=seagreen]
> Thanks Chris.
> I had a look around to try and find information about it. Where would I
> find more information about it?
> Thanks,
> Paul
> "Chris Wood" wrote:
>
set to back up the transaction logs of several specified databases. I open
up the backup database task, then choose <select one or more> from the
Database(s) prompt. When the drop down window opens, I select the radio box
for "these databases", and I check the databases that I want. I save the
database maintenance plan and run it and it works fine. If I open up the
backup database task again, and go to see what databases I have selected,
none are showing as selected. If I save the database maintenance plan and
run it, it fails with the following message, which does not tell me much:
Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5
F}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete End Progress DTExec: The package execution returned
DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
1.437 seconds. The package execution failed. The step failed.
This message contrasts with the text file report that shows:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
Report was generated on "pdcnt23".
Maintenance Plan: MaintenancePlan
Duration: 00:00:00
Status: Succeeded.
Details:
If I go back into the backup task and reselect the databases and save the
maintenance plan and run it, everything works fine.
This doesn't work as I would expect it to. Is there something I need to do?
Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
Thanks,
PaulPaul,
Losing the database is a known problem. MS is looking into it for a later
build of SQL2005.
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> I've created a database maintenance plan with backup database task which
> is
> set to back up the transaction logs of several specified databases. I
> open
> up the backup database task, then choose <select one or more> from the
> Database(s) prompt. When the drop down window opens, I select the radio
> box
> for "these databases", and I check the databases that I want. I save the
> database maintenance plan and run it and it works fine. If I open up the
> backup database task again, and go to see what databases I have selected,
> none are showing as selected. If I save the database maintenance plan and
> run it, it fails with the following message, which does not tell me much:
> Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506
E5F}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete End Progress DTExec: The package execution returned
> DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> 1.437 seconds. The package execution failed. The step failed.
> This message contrasts with the text file report that shows:
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> Report was generated on "pdcnt23".
> Maintenance Plan: MaintenancePlan
> Duration: 00:00:00
> Status: Succeeded.
> Details:
> If I go back into the backup task and reselect the databases and save the
> maintenance plan and run it, everything works fine.
> This doesn't work as I would expect it to. Is there something I need to
> do?
> Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> Thanks,
> Paul
>|||Thanks Chris.
I had a look around to try and find information about it. Where would I
find more information about it?
Thanks,
Paul
"Chris Wood" wrote:
> Paul,
> Losing the database is a known problem. MS is looking into it for a later
> build of SQL2005.
> Chris
> "PT" <PT@.discussions.microsoft.com> wrote in message
> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
>
>|||Paul,
Signon to Microsoft Connect:- https://connect.microsoft.com/default.aspx and
register for SQL
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:4C86DAAF-11E8-4CA7-B740-A3CF4BF32C69@.microsoft.com...[vbcol=seagreen]
> Thanks Chris.
> I had a look around to try and find information about it. Where would I
> find more information about it?
> Thanks,
> Paul
> "Chris Wood" wrote:
>
Database Maintenance Plan
Hello, everyone:
I have a Database Maintenance Plan that back up some databases and delete old backup files that more than two day. Can any one have idea which action is first, backup or delete old files?
Thanks
ZYTIt backs up first then deletes.
I have a Database Maintenance Plan that back up some databases and delete old backup files that more than two day. Can any one have idea which action is first, backup or delete old files?
Thanks
ZYTIt backs up first then deletes.
Database Maintenance Plan
A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?
I don't think you can change the plan owner, but you can try changing the owner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up your plan...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegr oups.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>
|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?
I don't think you can change the plan owner, but you can try changing the owner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up your plan...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegr oups.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>
|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.
Database Maintenance Plan
A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?I don't think you can change the plan owner, but you can try changing the owner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up your plan...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegroups.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?I don't think you can change the plan owner, but you can try changing the owner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up your plan...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegroups.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.
Wednesday, March 7, 2012
Database Maintenance Plan
A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?I don't think you can change the plan owner, but you can try changing the ow
ner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up
your plan...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegroups
.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?I don't think you can change the plan owner, but you can try changing the ow
ner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up
your plan...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegroups
.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.
Sunday, February 19, 2012
database logs
I am trying to reduce the physical size of a large database log. I have run several utilities - back up with the remove inactive entries from the transaction log checked, the DBCC shrinkfile utility (with a target size and a truncateonly option) and run DB maintenance to remove extra space. The properties of this log file show that it has reduced the size of the file, but the physical size of the file on the server still remains as big as it was.
Any suggestions on how to eliminate all the new free space I have created? I am looking to get the extra space on my server
Thanks.First check for any open transactions using dbcc opentran. Then follow the
steps in
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272318
For reasons why the log can fill up or grow unexpectadly check out
INF: Causes of SQL Transaction Log Filling Up
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q110139
INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317375
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karen" <anonymous@.discussions.microsoft.com> wrote in message
news:34FB692C-3644-45A6-823F-628A5F4C3F18@.microsoft.com...
> I am trying to reduce the physical size of a large database log. I have
run several utilities - back up with the remove inactive entries from the
transaction log checked, the DBCC shrinkfile utility (with a target size and
a truncateonly option) and run DB maintenance to remove extra space. The
properties of this log file show that it has reduced the size of the file,
but the physical size of the file on the server still remains as big as it
was.
> Any suggestions on how to eliminate all the new free space I have created?
I am looking to get the extra space on my server.
> Thanks.
Any suggestions on how to eliminate all the new free space I have created? I am looking to get the extra space on my server
Thanks.First check for any open transactions using dbcc opentran. Then follow the
steps in
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272318
For reasons why the log can fill up or grow unexpectadly check out
INF: Causes of SQL Transaction Log Filling Up
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q110139
INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317375
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karen" <anonymous@.discussions.microsoft.com> wrote in message
news:34FB692C-3644-45A6-823F-628A5F4C3F18@.microsoft.com...
> I am trying to reduce the physical size of a large database log. I have
run several utilities - back up with the remove inactive entries from the
transaction log checked, the DBCC shrinkfile utility (with a target size and
a truncateonly option) and run DB maintenance to remove extra space. The
properties of this log file show that it has reduced the size of the file,
but the physical size of the file on the server still remains as big as it
was.
> Any suggestions on how to eliminate all the new free space I have created?
I am looking to get the extra space on my server.
> Thanks.
database logs
I am trying to reduce the physical size of a large database log. I have run
several utilities - back up with the remove inactive entries from the trans
action log checked, the DBCC shrinkfile utility (with a target size and a tr
uncateonly option) and run
DB maintenance to remove extra space. The properties of this log file show
that it has reduced the size of the file, but the physical size of the file
on the server still remains as big as it was.
Any suggestions on how to eliminate all the new free space I have created?
I am looking to get the extra space on my server.
Thanks.First check for any open transactions using dbcc opentran. Then follow the
steps in
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/defaul...b;en-us;Q272318
For reasons why the log can fill up or grow unexpectadly check out
INF: Causes of SQL Transaction Log Filling Up
http://support.microsoft.com/defaul...b;en-us;Q110139
INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server
http://support.microsoft.com/defaul...kb;EN-US;317375
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karen" <anonymous@.discussions.microsoft.com> wrote in message
news:34FB692C-3644-45A6-823F-628A5F4C3F18@.microsoft.com...
run several utilities - back up with the remove inactive entries from the
transaction log checked, the DBCC shrinkfile utility (with a target size and
a truncateonly option) and run DB maintenance to remove extra space. The
properties of this log file show that it has reduced the size of the file,
but the physical size of the file on the server still remains as big as it
was.
I am looking to get the extra space on my server.
several utilities - back up with the remove inactive entries from the trans
action log checked, the DBCC shrinkfile utility (with a target size and a tr
uncateonly option) and run
DB maintenance to remove extra space. The properties of this log file show
that it has reduced the size of the file, but the physical size of the file
on the server still remains as big as it was.
Any suggestions on how to eliminate all the new free space I have created?
I am looking to get the extra space on my server.
Thanks.First check for any open transactions using dbcc opentran. Then follow the
steps in
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/defaul...b;en-us;Q272318
For reasons why the log can fill up or grow unexpectadly check out
INF: Causes of SQL Transaction Log Filling Up
http://support.microsoft.com/defaul...b;en-us;Q110139
INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server
http://support.microsoft.com/defaul...kb;EN-US;317375
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karen" <anonymous@.discussions.microsoft.com> wrote in message
news:34FB692C-3644-45A6-823F-628A5F4C3F18@.microsoft.com...
quote:
> I am trying to reduce the physical size of a large database log. I have
run several utilities - back up with the remove inactive entries from the
transaction log checked, the DBCC shrinkfile utility (with a target size and
a truncateonly option) and run DB maintenance to remove extra space. The
properties of this log file show that it has reduced the size of the file,
but the physical size of the file on the server still remains as big as it
was.
quote:
> Any suggestions on how to eliminate all the new free space I have created?
I am looking to get the extra space on my server.
quote:
> Thanks.
Friday, February 17, 2012
Database log truncated: Database
Suddenly the bank me this message came back:
Database log truncated: Database: <nome_banco>
and oh some tables were simply without any registration, what did happen?
How do I do to recover my records?
I thank at once.Frank
What do mean by saing "and oh some tables were simply without any
registration, what did happen?"
Im order to restore your data you should have full backup of you database .
To restore data at point of time you have to backup log file too.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:uEdn4PMqDHA.2964@.tk2msftngp13.phx.gbl...
>
> Suddenly the bank me this message came back:
> Database log truncated: Database: <nome_banco>
> and oh some tables were simply without any registration, what did happen?
> How do I do to recover my records?
> I thank at once.
>
>
Database log truncated: Database: <nome_banco>
and oh some tables were simply without any registration, what did happen?
How do I do to recover my records?
I thank at once.Frank
What do mean by saing "and oh some tables were simply without any
registration, what did happen?"
Im order to restore your data you should have full backup of you database .
To restore data at point of time you have to backup log file too.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:uEdn4PMqDHA.2964@.tk2msftngp13.phx.gbl...
>
> Suddenly the bank me this message came back:
> Database log truncated: Database: <nome_banco>
> and oh some tables were simply without any registration, what did happen?
> How do I do to recover my records?
> I thank at once.
>
>
Subscribe to:
Posts (Atom)