can't backup DB after detach/attach

I moved a database to a new cluster using detach/attach. Now I am unable to
back it up.
When I do it manually it flashes very quickly saying that it has finished,
but the backup file is only 0 KB. When I run it as part of a maintenance plan
I am getting the following error in the logs:
[2] Database myDB: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
I am able to backup other databases on this instance so I am not sure why
this one is being so persnickity. Please let me know if you have any ideas.
Thanks.well , have you read error log file ?
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:9D5E94FC-5BAC-424E-8FAE-72B4908248BF@.microsoft.com...
>I moved a database to a new cluster using detach/attach. Now I am unable to
> back it up.
> When I do it manually it flashes very quickly saying that it has finished,
> but the backup file is only 0 KB. When I run it as part of a maintenance
> plan
> I am getting the following error in the logs:
> [2] Database myDB: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]Cannot open backup device
> 'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> terminating abnormally.
>
> I am able to backup other databases on this instance so I am not sure why
> this one is being so persnickity. Please let me know if you have any
> ideas.
> Thanks.

Can't back up Encryption Key

I am trying to backup Encryption Key for my reporting service. Configuration tool, prompts for a encryption key file location and a strong password. When I provide the same and click OK, I get the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's (Exception from HRESULT: 0x80070A91)
End of inner exception stack trace
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)

I have tried with passwords with different combination but none of them seem to help. Any ideas?

It looks like your system has a password complexity filter installed. If you search on the error message, you will see a number of articles explaining how you can build and install one; I would check to see if that's the case first.

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

Hi

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

Can't back up Encryption Key

I am trying to backup Encryption Key for my reporting service. Configuration tool, prompts for a encryption key file location and a strong password. When I provide the same and click OK, I get the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's (Exception from HRESULT: 0x80070A91)
End of inner exception stack trace
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)

I have tried with passwords with different combination but none of them seem to help. Any ideas?

It looks like your system has a password complexity filter installed. If you search on the error message, you will see a number of articles explaining how you can build and install one; I would check to see if that's the case first.

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

Hi

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

Can't back up Encryption Key

I am trying to backup Encryption Key for my reporting service. Configuration tool, prompts for a encryption key file location and a strong password. When I provide the same and click OK, I get the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's (Exception from HRESULT: 0x80070A91)
End of inner exception stack trace
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)

I have tried with passwords with different combination but none of them seem to help. Any ideas?

It looks like your system has a password complexity filter installed. If you search on the error message, you will see a number of articles explaining how you can build and install one; I would check to see if that's the case first.

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

Hi

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select

"Online" mode, I get an error asking me to select at least one source

file, but there is nothing to select (no files appear in the pop up

window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select

"Online" mode, I get an error asking me to select at least one source

file, but there is nothing to select (no files appear in the pop up

window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

cannot start trace

After going through all the configurations in Trace Properties, I clicked
Run, then I got this error back:
Failed to start a trace. SQL server does not exist or access denied.
The user I'm connecting to the server has full privileges on the databases.
Where should I check?
Thanks for any help,
Bingbing wrote:
> After going through all the configurations in Trace Properties, I
> clicked Run, then I got this error back:
> Failed to start a trace. SQL server does not exist or access denied.
> The user I'm connecting to the server has full privileges on the
> databases. Where should I check?
> Thanks for any help,
> Bing
You're not even getting to the server. Either the server name is
mistyped or your login name/password is incorrect.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Oh? In SQL Profiler, clicking File->New->Trace, then a window with title
'Connect to Server' pops up, in this window, SQL Server is set to local,
Connecting using Windows authentication. Clicking Ok in this window brings
up another window Trace Properties.
I think at this point I've already connected to the server fine. No?
Anyway, I tried changing server name from local to its hostname, it worked.
Odd, I was doing all this on the database server, how doesn't 'local' work?
Bing
"David Gugick" wrote:
> bing wrote:
> > After going through all the configurations in Trace Properties, I
> > clicked Run, then I got this error back:
> >
> > Failed to start a trace. SQL server does not exist or access denied.
> >
> > The user I'm connecting to the server has full privileges on the
> > databases. Where should I check?
> >
> > Thanks for any help,
> >
> > Bing
> You're not even getting to the server. Either the server name is
> mistyped or your login name/password is incorrect.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||bing wrote:
> Oh? In SQL Profiler, clicking File->New->Trace, then a window with
> title 'Connect to Server' pops up, in this window, SQL Server is set
> to local, Connecting using Windows authentication. Clicking Ok in
> this window brings up another window Trace Properties.
> I think at this point I've already connected to the server fine. No?
> Anyway, I tried changing server name from local to its hostname, it
> worked. Odd, I was doing all this on the database server, how doesn't
> 'local' work?
"(local)" not "local". I prefer using the real server name just as you
ended up doing. I'm not exacly sure what the problem was. The error
message you posted indicated you never made it to the server (my
username/pwd comment aside). But if what you're saying is you get past
the login screen, then you are in fact logging in successfully to the
server. It's just that at that point the trace has not started. You have
only verified with Profiler that you have a valid admin login to the
server. Just stick with the real server name and you should be fine.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Sorry about not being precise. It's my typo. Yes, it is '(local)' rather
than 'local'.
Bing
"David Gugick" wrote:
> bing wrote:
> > Oh? In SQL Profiler, clicking File->New->Trace, then a window with
> > title 'Connect to Server' pops up, in this window, SQL Server is set
> > to local, Connecting using Windows authentication. Clicking Ok in
> > this window brings up another window Trace Properties.
> >
> > I think at this point I've already connected to the server fine. No?
> >
> > Anyway, I tried changing server name from local to its hostname, it
> > worked. Odd, I was doing all this on the database server, how doesn't
> > 'local' work?
> "(local)" not "local". I prefer using the real server name just as you
> ended up doing. I'm not exacly sure what the problem was. The error
> message you posted indicated you never made it to the server (my
> username/pwd comment aside). But if what you're saying is you get past
> the login screen, then you are in fact logging in successfully to the
> server. It's just that at that point the trace has not started. You have
> only verified with Profiler that you have a valid admin login to the
> server. Just stick with the real server name and you should be fine.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>

Cannot start DTC in Enterprise Mgr

Hello, experts!

On Sunday, as part of routine maintenance, we had to shut down our clustered servers. When we tried to bring them back up, they would not recognize our array unless we disabled the cluster service. It was agreed that we should disable the cluster service (it's caused nothing but problems due to poor implementation and vendor software support), but now we're having difficulties with SQL Server. We're having several "small" problems (i.e. unable to remove our old instance of SQL Server), but the main issue is that our client cannot connect to our server. They are able to ping us and connect to our development database (not affected by the failure), but cannot connect to the production database. Currently, the most obvious difference between production and development is that development displays a green icon (running) for both Distributed Transaction Coordinator and Full-Text Search in Support Services (Enterprise Mgr), whereas production has a red (stopped) icon for both. Also, we previously identified that MSDTC was not running and that it was inaccessible in Component Services, so we uninstalled and reinstalled. We were then able to access MSDTC in Component Services. That said, when I attempt to start DTC or Full-Text Search in Support Services, I receive the following error message:

An error 1722 - (The RPC server is unavailable) occurred while performing this service operation on the MSDTC service.

I've troubleshot this error message and verified that both RPC and DTC are started in the Services menu, that both services are set to start automatically and that both are using "Network Service" login. At this point, I have no idea what could possibly be causing this problem or if this could even be related to our client's inability to connect to our SQL database. We're running SQL Server 2000 SP4 on Win Server 2003 Dell machines. Any assistance is much appreciated.

Thanks!

Can you discuss what steps you took to disable the cluster service? Also, was this MSCS, Veritas Cluster or other?

When an instance is installed as clustered, the configuration is set up to only run under the cluster. This may be causing some of the troubles.

|||

Hi Kevin,

Thank you for the response. We're using MSCS. We disabled the Cluster Disk Driver in Device Manager, then disabled the Cluster Service in Services.

How would we go about utilizing a previously clustered server in a non-clustered capacity? Would we have to rebuild the server with a clean install of Windows Server and SQL Server?

|||

Did you cluster MS DTC? If not, that is most likely your issue. On a clustered implementation, DTC needs to be clustered as well. It's done at the OS level.

Try this: http://support.microsoft.com/kb/294209/ or http://support.microsoft.com/kb/243204/en-us

Cannot show editor for this task in SQL 2005 Management Studio

Hi,

I have setup a db backup maintenance plan with the SQL 2005 Mgmt Studio tool. When I double-clicked the 'Back up Database Task' object I got the following error message. My SQL 2005 client has been patched with SQL 2005 SP2. Does someone know about this problem? Thanks - Joe

Cannot show editor for this task.

Additional information:

Value of '4/17/2007 12:00:00 AM' is not valid for Value'. Value should be between 'MinDate' and 'MaxDate'. Parameter name: Value(System.Windows.Forms)

I haven't heard of this one before. Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Issues reported on the Connect site go directly into our internal issue tracking system so we don't lose any information. Be sure to note whether the maintenance plan existed before your updated to SP2 or if the plan is new.

Thanks,

Steve

|||I'm getting this as well. Did you get an idea when this might be fixed.|||I'm getting this also. Did you get an idea when this might be fixed.|||

hello I have got the same problem, but in spanish.

The mantenience plan was created before updating to SP2, and now I can't edit the BackUp task.

I tryed diferent MSSMS Clients with the same server, and it always fails, so I assume this is from the server.

Error: (spanish)

No se puede mostrar el editor para esta tarea.

Información adicional:

El valor de '02/05/2007 0:00:00' no es válido para 'Value'. 'Value' debería estar entre 'MinDate' y 'MaxDate'.

Nombre del parámetro: Value (System.Windows.Forms)

|||

Strangely on my side, the day after having this error, everything was ok.

Did not apply any new service pack or correction att all.

Carl

|||

Solved same way, yesterday I created again one of the tasks, and today I can edit all them.

Summary: Solution, wait until tomorrow.

|||

Hello everyone,

Thanks for reporting this issue. The problem is that once the expiration date is reached, the UI cannot be displayed because the date value is earlier than what is allowed. While a solution is being worked out and will be available in a major release, a few work-arounds have been identified:

1. If no action is taken, on the day after the original expiration date, the "backup set will expire" option will be reset to a date that is 14 days from the current date and the task will be editable as usual.

2. If editing the task is required on the day it was set to expire, then one of the following two solutions can be used:

Solution A: The new task can be created in place of the existing task.

Solution B: The Backup Database task can be made editable by changing the “Backup set will expire” property in BIDS and importing the package back to the Maintenance Plan designer. Here are the steps to follow:

Edit your Maintenance Plan in the Server Business Intelligence Development Studio (BIDS)

· Find SQL Server Business Intelligence Development Studio on the Start menu under Microsoft SQL Server 2005.

· From the File menu, create a New Project of type “Integration Services Project”.

· To import your Maintenance Plan into your new project, in the Solution Explorer window, right click on the ‘SSIS Packages’ folder and choose the ‘Add Existing Package’ option.

· In the “Add Copy of Existing Package” dialog

o Set the Package Location to SQL Server

o Provide authentication for your server.

o In the Package Path field , click the browse button to display the packages on your server.

o Navigate to ‘SSIS Package’, then ‘Maintenance Plans’.

o Select your Maintenance Plan and click OK. You see the Maintenance Plan that you just imported under the ‘SSIS Packages’ folder.

· Right-Click the Backup Database Task and select Properties.

· In the list of properties, navigate to the “ExpireDate” option and change the date to be at least one day ahead of the current date.

· Save the Package.

· In the Solution Explorer window, click on the name of the package. In the Properties panel, locate the Full Path to the package’s .dtsx file. Select the path and copy it to the clipboard.

· Exit the Business Intelligence Development Studio.

Re-import the Edited Package

· In Management Studio, click the Connect button and choose “Integration Services…” and connect to your server.

· Under Stored Packages open “MSDB”.

· Right click on the “Maintenance Plans” folder and select “Import Package”.

o Select “File System”.

o In the Package Path text box, paste in the previously copied .dtsx file path.

o Click in the Package Name text box to set the name, and click OK.

· When prompted to overwrite the existing package, say “Yes”.

Given these updates, the Backup Database Task should be editable from the Maintenance Plan designer.

Sorry for the inconvenience.

-Sirish

Cannot show editor for this task in SQL 2005 Management Studio

Hi,

I have setup a db backup maintenance plan with the SQL 2005 Mgmt Studio tool. When I double-clicked the 'Back up Database Task' object I got the following error message. My SQL 2005 client has been patched with SQL 2005 SP2. Does someone know about this problem? Thanks - Joe

Cannot show editor for this task.

Additional information:

Value of '4/17/2007 12:00:00 AM' is not valid for Value'. Value should be between 'MinDate' and 'MaxDate'. Parameter name: Value(System.Windows.Forms)

I haven't heard of this one before. Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Issues reported on the Connect site go directly into our internal issue tracking system so we don't lose any information. Be sure to note whether the maintenance plan existed before your updated to SP2 or if the plan is new.

Thanks,

Steve

|||I'm getting this as well. Did you get an idea when this might be fixed.|||I'm getting this also. Did you get an idea when this might be fixed.|||

hello I have got the same problem, but in spanish.

The mantenience plan was created before updating to SP2, and now I can't edit the BackUp task.

I tryed diferent MSSMS Clients with the same server, and it always fails, so I assume this is from the server.

Error: (spanish)

No se puede mostrar el editor para esta tarea.

Información adicional:

El valor de '02/05/2007 0:00:00' no es válido para 'Value'. 'Value' debería estar entre 'MinDate' y 'MaxDate'.

Nombre del parámetro: Value (System.Windows.Forms)

|||

Strangely on my side, the day after having this error, everything was ok.

Did not apply any new service pack or correction att all.

Carl

|||

Solved same way, yesterday I created again one of the tasks, and today I can edit all them.

Summary: Solution, wait until tomorrow.

|||

Hello everyone,

Thanks for reporting this issue. The problem is that once the expiration date is reached, the UI cannot be displayed because the date value is earlier than what is allowed. While a solution is being worked out and will be available in a major release, a few work-arounds have been identified:

1. If no action is taken, on the day after the original expiration date, the "backup set will expire" option will be reset to a date that is 14 days from the current date and the task will be editable as usual.

2. If editing the task is required on the day it was set to expire, then one of the following two solutions can be used:

Solution A: The new task can be created in place of the existing task.

Solution B: The Backup Database task can be made editable by changing the “Backup set will expire” property in BIDS and importing the package back to the Maintenance Plan designer. Here are the steps to follow:

Edit your Maintenance Plan in the Server Business Intelligence Development Studio (BIDS)

· Find SQL Server Business Intelligence Development Studio on the Start menu under Microsoft SQL Server 2005.

· From the File menu, create a New Project of type “Integration Services Project”.

· To import your Maintenance Plan into your new project, in the Solution Explorer window, right click on the ‘SSIS Packages’ folder and choose the ‘Add Existing Package’ option.

· In the “Add Copy of Existing Package” dialog

o Set the Package Location to SQL Server

o Provide authentication for your server.

o In the Package Path field , click the browse button to display the packages on your server.

o Navigate to ‘SSIS Package’, then ‘Maintenance Plans’.

o Select your Maintenance Plan and click OK. You see the Maintenance Plan that you just imported under the ‘SSIS Packages’ folder.

· Right-Click the Backup Database Task and select Properties.

· In the list of properties, navigate to the “ExpireDate” option and change the date to be at least one day ahead of the current date.

· Save the Package.

· In the Solution Explorer window, click on the name of the package. In the Properties panel, locate the Full Path to the package’s .dtsx file. Select the path and copy it to the clipboard.

· Exit the Business Intelligence Development Studio.

Re-import the Edited Package

· In Management Studio, click the Connect button and choose “Integration Services…” and connect to your server.

· Under Stored Packages open “MSDB”.

· Right click on the “Maintenance Plans” folder and select “Import Package”.

o Select “File System”.

o In the Package Path text box, paste in the previously copied .dtsx file path.

o Click in the Package Name text box to set the name, and click OK.

· When prompted to overwrite the existing package, say “Yes”.

Given these updates, the Backup Database Task should be editable from the Maintenance Plan designer.

Sorry for the inconvenience.

-Sirish

Cannot show editor for this task in SQL 2005 Management Studio

Hi,

I have setup a db backup maintenance plan with the SQL 2005 Mgmt Studio tool. When I double-clicked the 'Back up Database Task' object I got the following error message. My SQL 2005 client has been patched with SQL 2005 SP2. Does someone know about this problem? Thanks - Joe

Cannot show editor for this task.

Additional information:

Value of '4/17/2007 12:00:00 AM' is not valid for Value'. Value should be between 'MinDate' and 'MaxDate'. Parameter name: Value(System.Windows.Forms)

I haven't heard of this one before. Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Issues reported on the Connect site go directly into our internal issue tracking system so we don't lose any information. Be sure to note whether the maintenance plan existed before your updated to SP2 or if the plan is new.

Thanks,

Steve

|||I'm getting this as well. Did you get an idea when this might be fixed.|||I'm getting this also. Did you get an idea when this might be fixed.|||

hello I have got the same problem, but in spanish.

The mantenience plan was created before updating to SP2, and now I can't edit the BackUp task.

I tryed diferent MSSMS Clients with the same server, and it always fails, so I assume this is from the server.

Error: (spanish)

No se puede mostrar el editor para esta tarea.

Información adicional:

El valor de '02/05/2007 0:00:00' no es válido para 'Value'. 'Value' debería estar entre 'MinDate' y 'MaxDate'.

Nombre del parámetro: Value (System.Windows.Forms)

|||

Strangely on my side, the day after having this error, everything was ok.

Did not apply any new service pack or correction att all.

Carl

|||

Solved same way, yesterday I created again one of the tasks, and today I can edit all them.

Summary: Solution, wait until tomorrow.

|||

Hello everyone,

Thanks for reporting this issue. The problem is that once the expiration date is reached, the UI cannot be displayed because the date value is earlier than what is allowed. While a solution is being worked out and will be available in a major release, a few work-arounds have been identified:

1. If no action is taken, on the day after the original expiration date, the "backup set will expire" option will be reset to a date that is 14 days from the current date and the task will be editable as usual.

2. If editing the task is required on the day it was set to expire, then one of the following two solutions can be used:

Solution A: The new task can be created in place of the existing task.

Solution B: The Backup Database task can be made editable by changing the “Backup set will expire” property in BIDS and importing the package back to the Maintenance Plan designer. Here are the steps to follow:

Edit your Maintenance Plan in the Server Business Intelligence Development Studio (BIDS)

· Find SQL Server Business Intelligence Development Studio on the Start menu under Microsoft SQL Server 2005.

· From the File menu, create a New Project of type “Integration Services Project”.

· To import your Maintenance Plan into your new project, in the Solution Explorer window, right click on the ‘SSIS Packages’ folder and choose the ‘Add Existing Package’ option.

· In the “Add Copy of Existing Package” dialog

o Set the Package Location to SQL Server

o Provide authentication for your server.

o In the Package Path field , click the browse button to display the packages on your server.

o Navigate to ‘SSIS Package’, then ‘Maintenance Plans’.

o Select your Maintenance Plan and click OK. You see the Maintenance Plan that you just imported under the ‘SSIS Packages’ folder.

· Right-Click the Backup Database Task and select Properties.

· In the list of properties, navigate to the “ExpireDate” option and change the date to be at least one day ahead of the current date.

· Save the Package.

· In the Solution Explorer window, click on the name of the package. In the Properties panel, locate the Full Path to the package’s .dtsx file. Select the path and copy it to the clipboard.

· Exit the Business Intelligence Development Studio.

Re-import the Edited Package

· In Management Studio, click the Connect button and choose “Integration Services…” and connect to your server.

· Under Stored Packages open “MSDB”.

· Right click on the “Maintenance Plans” folder and select “Import Package”.

o Select “File System”.

o In the Package Path text box, paste in the previously copied .dtsx file path.

o Click in the Package Name text box to set the name, and click OK.

· When prompted to overwrite the existing package, say “Yes”.

Given these updates, the Backup Database Task should be editable from the Maintenance Plan designer.

Sorry for the inconvenience.

-Sirish

|||

You can select the backup mainplan in the designer and press F4 to open the properties of the maintenanceplan in the designer.In the properties you can change the expiry date, this allows you to open the plan again for edit.

Cannot restore db

I'm trying to restore a Db from my web site back to my local machine.

Whichever way try, I get an error message saying

RESTORE detected an error on page (0:0)in database "new databasename"

> as read from the backup

Can anyone tell me what the error might be?

Many thanks

post back the restore database statement you used... also check the backup set .... if it is sql server 2005 use verify only option to verify the backup set... i doubt its corrupted.

Madhu

|||

Madhu,

I'm a newbie to SQL...

The backup was created by my web host - I have no control over how it is was created.

My database is SQL 2005 Express and I am trying to restore using SQL Server Management Studio Express - I do not see how to use "verfiy" using this tool.

Please can you give me some more guidance?

Many thanks for your help so far.

Cannot restore db

I'm trying to restore a Db from my web site back to my local machine.

Whichever way try, I get an error message saying

RESTORE detected an error on page (0:0)in database "new databasename"

> as read from the backup

Can anyone tell me what the error might be?

Many thanks

post back the restore database statement you used... also check the backup set .... if it is sql server 2005 use verify only option to verify the backup set... i doubt its corrupted.

Madhu

|||

Madhu,

I'm a newbie to SQL...

The backup was created by my web host - I have no control over how it is was created.

My database is SQL 2005 Express and I am trying to restore using SQL Server Management Studio Express - I do not see how to use "verfiy" using this tool.

Please can you give me some more guidance?

Many thanks for your help so far.