Database Mirroring - 'NT AUTHORITY\ANONYMOUS LOGON.' failed

Hello,

I have set up 3 servers - Primary, Mirror and Witness. When I run the database mirroring wizard all my endpoints are configured, but when i start the mirroring service i get a 1418 error - in the logs in says -

Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 10.20.1.5]

I have looked through the BOL and can't find anything helpful. - I'm pretty new to SQL server, so any help is very much appreciated!

Thanks

Kerpoise

This is not a SQL problem but an authentication issue. The right approach is to follow the guidance of the authentication troubleshooting whitepaper: http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerberr.mspx

HTH,
~ Remus

|||But why is my Primary server trying to logon as NT AUTHORITY/ANONYMOUS LOGON? When I have defined my logon through the Mirroring Wizard as a sysadmin account, with enabled Connect privileges on all servers.

I can't find a simple solution in the white paper. Isn't there a simple way to either - authenticate as a sysadmin account, or to allow NT AUTHORITY/ANONYMOUS to have CONNECT privileges to all servers?

It seems like this should be a very quick thing to do, but I really can't figure it out.

Please help!|||

Do not grant connect permission to ANONYMOUS LOGON.

When connecting the two instances what gets authenticated is the 'service account', the Windows account that runs the SQL Server instance. Depending on how you insnstalled the instances, the appropiate action is:
- if installed as 'LOCAL SERVICE': you must change the service account, it will never work. The SQL Management console in mmc has an option to change the service account, selecta different account.
- if installed as 'NETWORK SERVICE' or 'LocalSystem': you have to register the service SPN for Kerberos authentication to succeed. Use a tool like setspn.exe (available at microsoft download center) and register the SPN. Mirroring will use an SPN on the format 'MSSQLSvc/<partnername>:<partnerport>'. Also, make sure the AUTHENTICATION option on the mirroring endpoint is WINDOWS, WINDOWS NEGOTIATE or WINDOWS KERBEROS (in other words NTLM will not work). After registering the two SPNs (both for mirror and principal!), the authentication will resolve to the machine account ('DOMAIN\MachineName$'), you must create a login for this account and grant connect permission to it.
- if installed as a local account ('PrincipalMachine\LocalAccount' and/or 'MirrorMachine\LocalAccount'): it will not work, you must change the service account(s).
- if installed as domain account ('DOMAIN\UserName'), then it should work as long as both the mirror and the principal are in the same domain, or there is a trust relationship between their domains.

An alternative is to use certificate based authentication, then the whole domain/user/SPNs issue vanishes as the authentication will use a diferent protocol (SChannel's TLS).

HTH,
~ Remus

Database Mirroring

Im trying to get mirroring working go my endpoints set using the wizard,
the servers are called server1 and server2 when I trying to start
mirroring I get "specify the FQDN for each server, and click start
mirroring again" the computers see each other as server1 and server2 is
there away round this error ?You should follow the recommandation of the following topic on the Books on
Line:
SQL Server Database Engine -> Administering the Database Engine ->
Configuring High Availability -> Database Mirroring -> Setting Up Database
Mirroring -> Specifying a Server Network Address(Database Mirroring)
Gilberto
"sambino" wrote:

> Im trying to get mirroring working go my endpoints set using the wizard,
> the servers are called server1 and server2 when I trying to start
> mirroring I get "specify the FQDN for each server, and click start
> mirroring again" the computers see each other as server1 and server2 is
> there away round this error ?
>

Database Mirroring

Im trying to get mirroring working go my endpoints set using the wizard,
the servers are called server1 and server2 when I trying to start
mirroring I get "specify the FQDN for each server, and click start
mirroring again" the computers see each other as server1 and server2 is
there away round this error ?You should follow the recommandation of the following topic on the Books on
Line:
SQL Server Database Engine -> Administering the Database Engine ->
Configuring High Availability -> Database Mirroring -> Setting Up Database
Mirroring -> Specifying a Server Network Address(Database Mirroring)
Gilberto
"sambino" wrote:
> Im trying to get mirroring working go my endpoints set using the wizard,
> the servers are called server1 and server2 when I trying to start
> mirroring I get "specify the FQDN for each server, and click start
> mirroring again" the computers see each other as server1 and server2 is
> there away round this error ?
>

Database maintence plan

I have looked at the wizard for creating a database
maintenance plan and there are a lot of options. We have
30 databases on each of 2 clustered SQL2000 servers.
Originally I set up seperate backup jobs for each
database and transaction log and scheduled them to run
each night. This leaves to much room for error. I may
forget a backup or transaction log. I assume that the
maint. plan will backup databases and transaction logs
and truncate the transaction logs on all databases. There
is less chance of me forgetting to add a backup. What
options are recommended when running the database maint.
plan wizard?
Thank You
TomWe have quite a few databases on one of our servers. I threw together a
quick and simple way to back them up using sp_MSforeachdb:
If you want to see how it works on your server, replace
EXEC (@.sql)
with
PRINT @.sql
and run it on your server
You will probably have to change the backup location to fit your
environment.
EXEC sp_MSforeachdb
'IF N''?'' NOT IN(''model'' ,''tempdb'', ''distribution'', ''Northwind'',
''pubs'')
BEGIN
DECLARE @.sql varchar(1000);
set @.sql = ''BACKUP DATABASE '' + (''?'') + '' TO DISK =''''D:\MSSQL2000\MSSQL\BACKUP\'' + (''?'') + ''.bak'''' WITH INIT''
EXEC (@.sql)
END'
Keith
"Tom" <anonymous@.discussions.microsoft.com> wrote in message
news:137b01c47bc0$0d162970$a301280a@.phx.gbl...
> I have looked at the wizard for creating a database
> maintenance plan and there are a lot of options. We have
> 30 databases on each of 2 clustered SQL2000 servers.
> Originally I set up seperate backup jobs for each
> database and transaction log and scheduled them to run
> each night. This leaves to much room for error. I may
> forget a backup or transaction log. I assume that the
> maint. plan will backup databases and transaction logs
> and truncate the transaction logs on all databases. There
> is less chance of me forgetting to add a backup. What
> options are recommended when running the database maint.
> plan wizard?
> Thank You
> Tom

Database maintence plan

I have looked at the wizard for creating a database
maintenance plan and there are a lot of options. We have
30 databases on each of 2 clustered SQL2000 servers.
Originally I set up seperate backup jobs for each
database and transaction log and scheduled them to run
each night. This leaves to much room for error. I may
forget a backup or transaction log. I assume that the
maint. plan will backup databases and transaction logs
and truncate the transaction logs on all databases. There
is less chance of me forgetting to add a backup. What
options are recommended when running the database maint.
plan wizard?
Thank You
Tom
We have quite a few databases on one of our servers. I threw together a
quick and simple way to back them up using sp_MSforeachdb:
If you want to see how it works on your server, replace
EXEC (@.sql)
with
PRINT @.sql
and run it on your server
You will probably have to change the backup location to fit your
environment.
EXEC sp_MSforeachdb
'IF N''?'' NOT IN(''model'' ,''tempdb'', ''distribution'', ''Northwind'',
''pubs'')
BEGIN
DECLARE @.sql varchar(1000);
set @.sql = ''BACKUP DATABASE '' + (''?'') + '' TO DISK =
''''D:\MSSQL2000\MSSQL\BACKUP\'' + (''?'') + ''.bak'''' WITH INIT''
EXEC (@.sql)
END'
Keith
"Tom" <anonymous@.discussions.microsoft.com> wrote in message
news:137b01c47bc0$0d162970$a301280a@.phx.gbl...
> I have looked at the wizard for creating a database
> maintenance plan and there are a lot of options. We have
> 30 databases on each of 2 clustered SQL2000 servers.
> Originally I set up seperate backup jobs for each
> database and transaction log and scheduled them to run
> each night. This leaves to much room for error. I may
> forget a backup or transaction log. I assume that the
> maint. plan will backup databases and transaction logs
> and truncate the transaction logs on all databases. There
> is less chance of me forgetting to add a backup. What
> options are recommended when running the database maint.
> plan wizard?
> Thank You
> Tom

Database maintence plan

I have looked at the wizard for creating a database
maintenance plan and there are a lot of options. We have
30 databases on each of 2 clustered SQL2000 servers.
Originally I set up seperate backup jobs for each
database and transaction log and scheduled them to run
each night. This leaves to much room for error. I may
forget a backup or transaction log. I assume that the
maint. plan will backup databases and transaction logs
and truncate the transaction logs on all databases. There
is less chance of me forgetting to add a backup. What
options are recommended when running the database maint.
plan wizard?
Thank You
TomWe have quite a few databases on one of our servers. I threw together a
quick and simple way to back them up using sp_MSforeachdb:
If you want to see how it works on your server, replace
EXEC (@.sql)
with
PRINT @.sql
and run it on your server
You will probably have to change the backup location to fit your
environment.
EXEC sp_MSforeachdb
'IF N''?'' NOT IN(''model'' ,''tempdb'', ''distribution'', ''Northwind'',
''pubs'')
BEGIN
DECLARE @.sql varchar(1000);
set @.sql = ''BACKUP DATABASE '' + (''?'') + '' TO DISK =
''''D:\MSSQL2000\MSSQL\BACKUP'' + (''?'') + ''.bak'''' WITH INIT''
EXEC (@.sql)
END'
Keith
"Tom" <anonymous@.discussions.microsoft.com> wrote in message
news:137b01c47bc0$0d162970$a301280a@.phx.gbl...
> I have looked at the wizard for creating a database
> maintenance plan and there are a lot of options. We have
> 30 databases on each of 2 clustered SQL2000 servers.
> Originally I set up seperate backup jobs for each
> database and transaction log and scheduled them to run
> each night. This leaves to much room for error. I may
> forget a backup or transaction log. I assume that the
> maint. plan will backup databases and transaction logs
> and truncate the transaction logs on all databases. There
> is less chance of me forgetting to add a backup. What
> options are recommended when running the database maint.
> plan wizard?
> Thank You
> Tom

Database Maintenance problem

Hi again,
i was wondering if anyone has encountered this problem:
I make a database maintenance plan (through the wizard) because i want to
backup the
server files to another computer on my network
I have made a map to the other computer (as G:),
and i then go to the tab "Complete Backup" and then i select "Use this
directory" option
to select the directory for the baclup files in the other computer.
But, the listbox presented at me there, displays only the locals C:\ and D:\
drives,
not the other mapped one (G:).
I manually enter the full path name and of cource the job cannot execute.
Has anyone any solution to that ?
anthonybI use UNC paths and it works fine for me. Remember that YOU are not going
to be executing this plan it will be SQL Server Agent so G may have
absolutely no meaning to it whatsoever.
Allan
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Anthony Boudouvas" <anthonyb@.mediatel.gr> wrote in message
news:eK88Tv0VDHA.2252@.TK2MSFTNGP10.phx.gbl...
> Hi again,
> i was wondering if anyone has encountered this problem:
> I make a database maintenance plan (through the wizard) because i want to
> backup the
> server files to another computer on my network
> I have made a map to the other computer (as G:),
> and i then go to the tab "Complete Backup" and then i select "Use this
> directory" option
> to select the directory for the baclup files in the other computer.
> But, the listbox presented at me there, displays only the locals C:\ and
D:\
> drives,
> not the other mapped one (G:).
> I manually enter the full path name and of cource the job cannot execute.
> Has anyone any solution to that ?
> anthonyb
>

Database Maintenance Planner option disabled

I am using SQL Server 2000 and need to run the maintenance plan wizard,
but the "Database Maintenance Planner" option in the Tools menu is
disabled (greyed out) no matter which node I click on. Google searches
have turned up nothing. Help!
Is SQL Server Agent enabled and running?
<unimatter@.gmail.com> wrote in message
news:1167501594.458835.85780@.s34g2000cwa.googlegro ups.com...
>I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
|||Hi
"unimatter@.gmail.com" wrote:

> I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
I am not sure why it is greyed out, but why not write your own call to
xp_sqlmaint or use sqlmaint.exe from the command prompt?
John
|||Hi
Just to add, the "database maintenance plan" option is normally available
when you are on the server node, datebase node etc.
John

Database Maintenance Planner option disabled

I am using SQL Server 2000 and need to run the maintenance plan wizard,
but the "Database Maintenance Planner" option in the Tools menu is
disabled (greyed out) no matter which node I click on. Google searches
have turned up nothing. Help!Is SQL Server Agent enabled and running?
<unimatter@.gmail.com> wrote in message
news:1167501594.458835.85780@.s34g2000cwa.googlegroups.com...
>I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>|||Hi
"unimatter@.gmail.com" wrote:

> I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
I am not sure why it is greyed out, but why not write your own call to
xp_sqlmaint or use sqlmaint.exe from the command prompt?
John|||Hi
Just to add, the "database maintenance plan" option is normally available
when you are on the server node, datebase node etc.
John

Database Maintenance Planner option disabled

I am using SQL Server 2000 and need to run the maintenance plan wizard,
but the "Database Maintenance Planner" option in the Tools menu is
disabled (greyed out) no matter which node I click on. Google searches
have turned up nothing. Help!Is SQL Server Agent enabled and running?
<unimatter@.gmail.com> wrote in message
news:1167501594.458835.85780@.s34g2000cwa.googlegroups.com...
>I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>|||Hi
"unimatter@.gmail.com" wrote:
> I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
I am not sure why it is greyed out, but why not write your own call to
xp_sqlmaint or use sqlmaint.exe from the command prompt?
John|||Hi
Just to add, the "database maintenance plan" option is normally available
when you are on the server node, datebase node etc.
John

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.

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.

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

Database Maintenance Plan Wizard

I used the Database Maintenance Plan Wizard to create backup plans for the
master, msdb, and model databases. The model database backs up just fine, but
I get the following error for the master and msdb:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan master, msdb'' (0x27C15923C7908543B33AADC8F4379A07) -
Status: Failed - Invoked on: 2004-12-17 00:00:01 - Message: The job failed.
The Job was invoked by Schedule 72 (Schedule 1). The last step to run was
step 1 (Step 1).
John Schuster
That is because they are set to SIMPLE mode and you can not backup the log
on a db that is in SIMPLE mode. Create a new plan just for the system db's
and don't issue log backups. Bythe way you don't need to do log backups on
the Model either since it is only a template for new databases.
Andrew J. Kelly SQL MVP
"John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
news:9B4E59C1-9C94-4D20-939E-AD96527A80BE@.microsoft.com...
>I used the Database Maintenance Plan Wizard to create backup plans for the
> master, msdb, and model databases. The model database backs up just fine,
> but
> I get the following error for the master and msdb:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
> Plan
> 'DB Maintenance Plan master, msdb'' (0x27C15923C7908543B33AADC8F4379A07) -
> Status: Failed - Invoked on: 2004-12-17 00:00:01 - Message: The job
> failed.
> The Job was invoked by Schedule 72 (Schedule 1). The last step to run was
> step 1 (Step 1).
> --
> John Schuster
|||Thank you very much.
"Andrew J. Kelly" wrote:

> That is because they are set to SIMPLE mode and you can not backup the log
> on a db that is in SIMPLE mode. Create a new plan just for the system db's
> and don't issue log backups. Bythe way you don't need to do log backups on
> the Model either since it is only a template for new databases.
> --
> Andrew J. Kelly SQL MVP
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:9B4E59C1-9C94-4D20-939E-AD96527A80BE@.microsoft.com...
>
>

Database Maintenance Plan Wizard

I cannot run the DB Maint. Plan Wizard, when I trying I get the following
error (right from the start):
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Unable to execute requested command.
Method not found: 'Void
Microsoft.SqlServer.Management.DatabaseMaintenance .TaskUIUtils..ctor()'.
(Microsoft.SqlServer.Management.MaintenancePlanWiz ard)
BUTTONS:
OK
I do have SSIS installed, and I can see that the service is running in the
SS Configuration Manager.
The version of SQL:
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
Any help would be very much appreciated!
Wanted to include for details on install:
Microsoft SQL Server Management Studio9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)2000.086.3959.00
(srv03_sp2_rtm.070216-1710)
Microsoft MSXML2.6 3.0 6.0
Microsoft Internet Explorer6.0.3790.1830
Microsoft .NET Framework2.0.50727.1433
Operating System5.2.3790
"Scott" wrote:

> I cannot run the DB Maint. Plan Wizard, when I trying I get the following
> error (right from the start):
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Cannot show requested dialog.
> --
> ADDITIONAL INFORMATION:
> Unable to execute requested command.
> --
> Method not found: 'Void
> Microsoft.SqlServer.Management.DatabaseMaintenance .TaskUIUtils..ctor()'.
> (Microsoft.SqlServer.Management.MaintenancePlanWiz ard)
> --
> BUTTONS:
> OK
> --
>
> I do have SSIS installed, and I can see that the service is running in the
> SS Configuration Manager.
> The version of SQL:
> Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
> Windows NT 5.2 (Build 3790: Service Pack 2)
> Any help would be very much appreciated!
|||RELOADED SP2, which seems to have fixed it.
"Scott" wrote:

> I cannot run the DB Maint. Plan Wizard, when I trying I get the following
> error (right from the start):
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Cannot show requested dialog.
> --
> ADDITIONAL INFORMATION:
> Unable to execute requested command.
> --
> Method not found: 'Void
> Microsoft.SqlServer.Management.DatabaseMaintenance .TaskUIUtils..ctor()'.
> (Microsoft.SqlServer.Management.MaintenancePlanWiz ard)
> --
> BUTTONS:
> OK
> --
>
> I do have SSIS installed, and I can see that the service is running in the
> SS Configuration Manager.
> The version of SQL:
> Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
> Windows NT 5.2 (Build 3790: Service Pack 2)
> Any help would be very much appreciated!

Database Maintenance Plan Wizard

I cannot run the DB Maint. Plan Wizard, when I trying I get the following
error (right from the start):
TITLE: Microsoft SQL Server Management Studio
--
Cannot show requested dialog.
--
ADDITIONAL INFORMATION:
Unable to execute requested command.
--
Method not found: 'Void
Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.
(Microsoft.SqlServer.Management.MaintenancePlanWizard)
--
BUTTONS:
OK
--
I do have SSIS installed, and I can see that the service is running in the
SS Configuration Manager.
The version of SQL:
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
Any help would be very much appreciated!Wanted to include for details on install:
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00
(srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.2.3790
"Scott" wrote:
> I cannot run the DB Maint. Plan Wizard, when I trying I get the following
> error (right from the start):
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Cannot show requested dialog.
> --
> ADDITIONAL INFORMATION:
> Unable to execute requested command.
> --
> Method not found: 'Void
> Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.
> (Microsoft.SqlServer.Management.MaintenancePlanWizard)
> --
> BUTTONS:
> OK
> --
>
> I do have SSIS installed, and I can see that the service is running in the
> SS Configuration Manager.
> The version of SQL:
> Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
> Windows NT 5.2 (Build 3790: Service Pack 2)
> Any help would be very much appreciated!|||RELOADED SP2, which seems to have fixed it.
"Scott" wrote:
> I cannot run the DB Maint. Plan Wizard, when I trying I get the following
> error (right from the start):
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Cannot show requested dialog.
> --
> ADDITIONAL INFORMATION:
> Unable to execute requested command.
> --
> Method not found: 'Void
> Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.
> (Microsoft.SqlServer.Management.MaintenancePlanWizard)
> --
> BUTTONS:
> OK
> --
>
> I do have SSIS installed, and I can see that the service is running in the
> SS Configuration Manager.
> The version of SQL:
> Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
> Windows NT 5.2 (Build 3790: Service Pack 2)
> Any help would be very much appreciated!

database maintenance plan question

What type of backup does the SQL maintenance plan wizard use? Complete,
differencial?
Thanks
John
When using a Maintenance Plan to perform a Backup the SQLMAINT utility is
called with the -BkUpDB switch. This switch performs a full database backup,
backing up the entire database.
- Peter Ward
WARDY IT Solutions
"JP Breton" wrote:

> What type of backup does the SQL maintenance plan wizard use? Complete,
> differencial?
> Thanks
> John
>
>
>
|||Thanks for the quick reply P
Regards
JP
"P. Ward" <peter@.remove_online.wardyit.com> wrote in message
news:21181E36-3453-4FCB-8F12-D49BC1DBD200@.microsoft.com...[vbcol=seagreen]
> When using a Maintenance Plan to perform a Backup the SQLMAINT utility is
> called with the -BkUpDB switch. This switch performs a full database
> backup,
> backing up the entire database.
> - Peter Ward
> WARDY IT Solutions
> "JP Breton" wrote:
|||Maint Wiz supports Log and Db backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JP Breton" <jpbreton@.videotron.ca> wrote in message news:uBFiOUkPFHA.2144@.TK2MSFTNGP09.phx.gbl...
> What type of backup does the SQL maintenance plan wizard use? Complete, differencial?
> Thanks
> John
>
>

database maintenance plan question

What type of backup does the SQL maintenance plan wizard use? Complete,
differencial?
Thanks
JohnWhen using a Maintenance Plan to perform a Backup the SQLMAINT utility is
called with the -BkUpDB switch. This switch performs a full database backup
,
backing up the entire database.
- Peter Ward
WARDY IT Solutions
"JP Breton" wrote:

> What type of backup does the SQL maintenance plan wizard use? Complete,
> differencial?
> Thanks
> John
>
>
>|||Thanks for the quick reply P
Regards
JP
"P. Ward" <peter@.remove_online.wardyit.com> wrote in message
news:21181E36-3453-4FCB-8F12-D49BC1DBD200@.microsoft.com...[vbcol=seagreen]
> When using a Maintenance Plan to perform a Backup the SQLMAINT utility is
> called with the -BkUpDB switch. This switch performs a full database
> backup,
> backing up the entire database.
> - Peter Ward
> WARDY IT Solutions
> "JP Breton" wrote:
>|||Maint Wiz supports Log and Db backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JP Breton" <jpbreton@.videotron.ca> wrote in message news:uBFiOUkPFHA.2144@.TK2MSFTNGP09.phx.
gbl...
> What type of backup does the SQL maintenance plan wizard use? Complete, di
fferencial?
> Thanks
> John
>
>

database maintenance plan question

What type of backup does the SQL maintenance plan wizard use? Complete,
differencial?
Thanks
JohnWhen using a Maintenance Plan to perform a Backup the SQLMAINT utility is
called with the -BkUpDB switch. This switch performs a full database backup,
backing up the entire database.
- Peter Ward
WARDY IT Solutions
"JP Breton" wrote:
> What type of backup does the SQL maintenance plan wizard use? Complete,
> differencial?
> Thanks
> John
>
>
>|||Thanks for the quick reply P
Regards
JP
"P. Ward" <peter@.remove_online.wardyit.com> wrote in message
news:21181E36-3453-4FCB-8F12-D49BC1DBD200@.microsoft.com...
> When using a Maintenance Plan to perform a Backup the SQLMAINT utility is
> called with the -BkUpDB switch. This switch performs a full database
> backup,
> backing up the entire database.
> - Peter Ward
> WARDY IT Solutions
> "JP Breton" wrote:
>> What type of backup does the SQL maintenance plan wizard use? Complete,
>> differencial?
>> Thanks
>> John
>>
>>|||Maint Wiz supports Log and Db backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JP Breton" <jpbreton@.videotron.ca> wrote in message news:uBFiOUkPFHA.2144@.TK2MSFTNGP09.phx.gbl...
> What type of backup does the SQL maintenance plan wizard use? Complete, differencial?
> Thanks
> John
>
>

Database Maintenance Plan - Update Data Optimization

Should we check the box "Reorganize data and index pages" on Database
Maintenance Plan wizard ? What's the benefit ?
Thanks.This will essentially do a DBCC DBREINDEX on each of your tables (assuming a
clustered index exists) and non-clustered indexes. See DBCC DBREINDEX in
BooksOnLine and
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/Optimize/SS2KIDBP.asp
for more details.
Andrew J. Kelly
SQL Server MVP
"John Smith" <someone@.nospam.com.us> wrote in message
news:Ogr%23fQOnDHA.2268@.TK2MSFTNGP12.phx.gbl...
> Should we check the box "Reorganize data and index pages" on Database
> Maintenance Plan wizard ? What's the benefit ?
> Thanks.
>|||And if you are running a 24x7 critical application that really must be
available all the time, you should be very careful with that check box. DBCC
DBREINDEX is not an 'online' operation (from the end user perspective) -- it
can result in severe blocking on a large table, making the table effectively
not available to the end user.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"John Smith" <someone@.nospam.com.us> wrote in message
news:Ogr%23fQOnDHA.2268@.TK2MSFTNGP12.phx.gbl...
> Should we check the box "Reorganize data and index pages" on Database
> Maintenance Plan wizard ? What's the benefit ?
> Thanks.
>