Database Overwritten: commands

Hello, I normally use the database backup and restore commands when I am
moving one database for one computer to another. This time however, I
brought over the raw files for the log and data. How can I get sql server
to incorporate these files into the server that I am placing them on. This
server does not have that database at all. I moved the files to the
location it normally places the log and datafiles, but when I brought SQL
server up, it did not show me those files in enterprise manager.
Any ideas how to utilize these files in SQL server?
Thanks in advance for your assistance!!!!!!Look up sp_attach_db and sp_detach_db in BOL (Books On-Line).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"C_Silin" <OverwhelmedButStillTrying@.hotmail.com> wrote in message
news:Xns9485989199631CSilinhotmailcom@.20
7.46.248.16...

quote:

> Hello, I normally use the database backup and restore commands when I am
> moving one database for one computer to another. This time however, I
> brought over the raw files for the log and data. How can I get sql server
> to incorporate these files into the server that I am placing them on.

This

quote:

> server does not have that database at all. I moved the files to the
> location it normally places the log and datafiles, but when I brought SQL
> server up, it did not show me those files in enterprise manager.
> Any ideas how to utilize these files in SQL server?
> Thanks in advance for your assistance!!!!!!

I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
instead of my home-grown utility to run Check Database commands. I used the
wizard to create the plan and used the SQL Server Agent account, which has
sysadmin rights for now. When the job runs, it dies with the error:
Executed as user: mydomain\username. 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: 11:47:22 AM Could not
create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
failed. The step failed.
I can't find any documentation on 0x800401F3. Any ideas? Thanks!There could be more detailed info if you right click on the Maintanence Plan
and click View History? (I'm note sure if you got the error message you
mentioned in your post from View History or not?)
--
Ekrem Ã?nsoy
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:DFEB0C82-CA48-489B-BCFC-D6EC3D125FB7@.microsoft.com...
>I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
> instead of my home-grown utility to run Check Database commands. I used
> the
> wizard to create the plan and used the SQL Server Agent account, which has
> sysadmin rights for now. When the job runs, it dies with the error:
> Executed as user: mydomain\username. 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: 11:47:22 AM Could not
> create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
> Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
> failed. The step failed.
> I can't find any documentation on 0x800401F3. Any ideas? Thanks!|||Jeff,
Here are some discussions for you to check out. Hope that one helps
http://p2p.wrox.com/topic.asp?TOPIC_ID=43327 Read the last post for this
one.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21769758.html
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=361588&SiteID=1
RLF
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:DFEB0C82-CA48-489B-BCFC-D6EC3D125FB7@.microsoft.com...
>I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
> instead of my home-grown utility to run Check Database commands. I used
> the
> wizard to create the plan and used the SQL Server Agent account, which has
> sysadmin rights for now. When the job runs, it dies with the error:
> Executed as user: mydomain\username. 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: 11:47:22 AM Could not
> create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
> Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
> failed. The step failed.
> I can't find any documentation on 0x800401F3. Any ideas? Thanks!|||The wrox thead recommended registry changes for IUSR. Which one? Repeat for
every domain controller?
The msdn thread below implies that you can only use SQL Security, not
integrated security, with a maintenance plan. Is that right? I have other
Agent jobs that use integrated security with no trouble. The user is
sysadmin and a domain administrator (as a test to see if that solved the
problem), so I don't know how much more privilege I can throw at it.
Most of these seem to be related to ASP pages. I'm not clear how that ties
in to a Database Maintenance plan. Or is it a problem with how Microsoft is
building the plan?
I appreciate the help - I just feel a little lost still. Thanks!
Jeff
"Russell Fields" wrote:
> Jeff,
> Here are some discussions for you to check out. Hope that one helps
> http://p2p.wrox.com/topic.asp?TOPIC_ID=43327 Read the last post for this
> one.
> http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21769758.html
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=361588&SiteID=1
> RLF
> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> news:DFEB0C82-CA48-489B-BCFC-D6EC3D125FB7@.microsoft.com...
> >I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
> > instead of my home-grown utility to run Check Database commands. I used
> > the
> > wizard to create the plan and used the SQL Server Agent account, which has
> > sysadmin rights for now. When the job runs, it dies with the error:
> >
> > Executed as user: mydomain\username. 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: 11:47:22 AM Could not
> > create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
> > Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
> > failed. The step failed.
> >
> > I can't find any documentation on 0x800401F3. Any ideas? Thanks!
>
>|||The error message I posted is the detailed message from the View History.
That's all there is, unless there is more detail somewhere else that I could
not find.
Thanks!
Jeff
"Ekrem Ã?nsoy" wrote:
> There could be more detailed info if you right click on the Maintanence Plan
> and click View History? (I'm note sure if you got the error message you
> mentioned in your post from View History or not?)
> --
> Ekrem Ã?nsoy|||Did you specify a Report file for the plan? If not, give it a try and check that file...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:45E493C1-ADC6-4392-8CD2-6EE0F34BD071@.microsoft.com...
> The error message I posted is the detailed message from the View History.
> That's all there is, unless there is more detail somewhere else that I could
> not find.
> Thanks!
> Jeff
> "Ekrem Önsoy" wrote:
>> There could be more detailed info if you right click on the Maintanence Plan
>> and click View History? (I'm note sure if you got the error message you
>> mentioned in your post from View History or not?)
>> --
>> Ekrem Önsoy
>|||I generated a new version of the plan with the wizard and set the logging,
but no log was created. I also tried the e-mail output. I thinkk it dies
before it gets that far. I added an output file in the Agent job, but it
just repeats the "Could not create DTS.Application because of error
0x800401F3".
"Tibor Karaszi" wrote:
> Did you specify a Report file for the plan? If not, give it a try and check that file...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>|||Jeff,
I observe that you are running 9.00.3042.00, which is the initial SQL
Server 2005 SP2. I know that this had some problems with Maintenance Plans,
but I cannot detail all of the exposures, though some are mentioned here:
http://support.microsoft.com/kb/933508
You probably want to be at least at Cumulative Update 1 of SP2
http://support.microsoft.com/kb/935356/ but there are quite a few
cumulative update packages that have follow CU1.
I have seen recommendations a few months ago by people I respect to go to
3186 (CU3) but not beyond.
http://support.microsoft.com/kb/939537. If you pursue this, be sure to
follow the link regarding a DTS side-effect at
http://support.microsoft.com/kb/919224/.
FYI, there will be an SP3 later this year, according to:
http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx
RLF
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:eMKMFMKpIHA.4912@.TK2MSFTNGP03.phx.gbl...
> Jeff,
> Here are some discussions for you to check out. Hope that one helps
> http://p2p.wrox.com/topic.asp?TOPIC_ID=43327 Read the last post for this
> one.
> http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21769758.html
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=361588&SiteID=1
> RLF
> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> news:DFEB0C82-CA48-489B-BCFC-D6EC3D125FB7@.microsoft.com...
>>I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
>> instead of my home-grown utility to run Check Database commands. I used
>> the
>> wizard to create the plan and used the SQL Server Agent account, which
>> has
>> sysadmin rights for now. When the job runs, it dies with the error:
>> Executed as user: mydomain\username. 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: 11:47:22 AM Could not
>> create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
>> Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
>> failed. The step failed.
>> I can't find any documentation on 0x800401F3. Any ideas? Thanks!
>|||Thanks! This is very helpful. I will work through the updates and see if
that helps. In the mean time, I can go back to running DBCC commands directly.
Jeff
"Russell Fields" wrote:
> Jeff,
> I observe that you are running 9.00.3042.00, which is the initial SQL
> Server 2005 SP2. I know that this had some problems with Maintenance Plans,
> but I cannot detail all of the exposures, though some are mentioned here:
> http://support.microsoft.com/kb/933508
...

Thursday, March 29, 2012

Database Movement

Database Movement

Thursday, March 8, 2012

Database Maintenance Plan dies with error 0x800401F3

Database Overwritten

Blog Archive

About Me