Hi george sibbald-364359

Everything i found said to upgrade tp SP2 but I was already on SP3

So as a last resort i re-applied SP3 and it fixed the Maint Plans...

Guess no one has seen this one

thanks

jim

Hi Tristan

the only thing i see under the database options>recovery is "Page Verify"; value is CHECKSUM

what am i missing

jim

Hi Melton

here is my test steps:

Launch SSMS

Select Databases

--create copy of Northwind database via SSMS

--Recovery Mode is set to FULL

Select Northwind >Task>Copy Database

(Northwind_new) created

--logout of SSMS and back in...

Thanks Marcin

very little training budget here

mostly "learn on your own'

Jim

Thanks Marcin

I need someone in the Los Angeles area

Jim

Thanks Steve

will see

Jim

Thanks Grant

Jim

Hi DH

okay

i got it

i was looking for "Properties" not "Edit" of the task

my issue here

Thanks

Jim

Hi DH

i am sorry but i just do not see Properties of the plan

i did a Modify adn then I am stuck

I have looked everywhere

i am looking at this in...

Hi DH

it looks right now like an admin is in the middle of changing the database name as he just called me

so I am going to wait until he is...

Thanks Grasshopper

that worked 🙂

wil i also have to use brackets in any alter database commands or any other commands for that matter ?

jim

Thanks GSquared

I will give it a try

Jim

Hi GSquared

is there a way to change the logical names to reflect the physical name ?

Thanks

jim

HI GSquared

I uses SSMS Copy Database Wizard

Databases>Northwind>Tasks>Copy Database

Jim