After Moving 2000 Databses To 2005 Error With Maintanance Plan
Oct 25, 2007
I have moved few databases in 2000 to a different server which run's on sql server 2005 and its not a instance ogf 2000.
I backed up databases in 2000 moved those files to other server and then restored them.
I had solved the problem of orphand users by deleting and adding again.
Now when i try to setup maintenance plan i have the following error after walking through the wizard
TITLE: Maintenance Plan Wizard Progress
------------------------------
Adding tasks to the maintenance plan failed.
------------------------------
ADDITIONAL INFORMATION:
Object reference not set to an instance of an object. (Microsoft.SqlServer.Management.MaintenancePlanWizard)
------------------------------
BUTTONS:
OK
------------------------------
what do i need to fix this????Any help is appreciated...
And what else do i need to make sure everything in 2005 are working fine apart from orphand user.
Please let me know
Thanks in advance
View 1 Replies
ADVERTISEMENT
Nov 28, 2006
i have a few maintanance plans on one database that i wanna copy acrross the whole plans to another database of same set up... is there a way to do this?
instead of re typing all plans?
View 6 Replies
View Related
Jun 13, 2001
Hi,
We have maintanance plan defined that runs every night for optimization, integrety check and full backup. Somehow, for last two days I have been receiving the following error about two out of four databases.
[1] Database customere7: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 15089: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot change the 'single user' option of a database while another user is in the database.
[2] Database producte7: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 15089: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot change the 'single user' option of a database while another user is in the database.
Strange thing is that we don't have this database in single user mode. They are the the main production databases and optimization and backup jobs run OK.
Please help me..I am not sure whether there is a major problem with database or what I should check. Does running integrety check after optimization job affect anything?
Daily activities seem normal with these databases.
Please help.
View 1 Replies
View Related
Nov 28, 2001
I have a Mantenance Plan running on my Production Server.
Each job has one step.
-Optimization (each week)
-Integrity Checks (each week)
-T-Log Backups (each hour)
-Full Back up (once a day)
The Job is saying the last three are failing but niether the SQL Server Logs or MS Application Log are reporting a success or faluire. "write to windows application log on faluire" is set for all of them. The backups are occuring, as the files are in thier destination.
Anyone experience this before? If so any advise?
Thanks,
Matt
View 2 Replies
View Related
Nov 9, 2007
I have moved my databases to 2000 to instance of 2005 on the same server.
Now i set databases offline in 2000 as i did upgrade use backup & recovery method.
& my connection string
Password=test;Persist Security Info=True;User ID=test;Initial Catalog=databasename;Data Source=ipaddress
i was using above connection string to connect when using 2000 databases form applications in the production machine
I get the following error when i am running my applications now after moving to 2005
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
IS it because i have two server on one server or
What do i need to do in order to fix this....tried several thing by searching nothing worked out..
Let me know
thanks
View 9 Replies
View Related
May 13, 2007
where is the maintanance wizard on SS2k5?
View 1 Replies
View Related
Mar 7, 2008
Hey guys I need to move a 2000DB to a 2005 just the database and the logins
Any suggestions of the best way to do this....
DTS backup attach database
Use the Upgrade Advisor....
View 1 Replies
View Related
Oct 23, 2006
What is the best way to move users from a 2000 sql server to a 2005 server? I have a bunch of issues with the passwords etc...
thanks for your time.
View 5 Replies
View Related
May 21, 2008
Hello, what is the easiest way to move a DB (tables and data) from SQL server 2000 to 2005.
Ive been trying to export the DB tables from 2000 using Excel, yet i get "cannot expand named range" errors on several of the tables.
Is excel the way to go? another way? Can i use backup/restore?
Note: also moving from one machine to another.
Thanks for any help.
View 2 Replies
View Related
Mar 30, 2008
Hi ,
I am working on a DWH project, and we decided few days ago to move from 2000 to 2005.
we installed the 2005 on the same server with two different instances for testing the 2005.
I migrate everything with the indexes but the issue is that queries at the 2005 take much more time than the same query on the 2000.
for example i have a nasty qry which join 14 tables. at the 2000 its take around 2.5 - 3 mins and at the 2005 its infinity , they both have the same indexes.
PLS ANYONE HAVE ANY IDEA WHATS THE PROBLEM ?
View 14 Replies
View Related
Jun 27, 2007
Hello:
I'm looking for a Project Plan template for Migration from MS SQL 2000 to MS sql 2005.
We apporeciate your help.
regards
William
View 8 Replies
View Related
Feb 21, 2007
We need to upgrade our HR system from SQL 2000 to SQL 2005. Support for SQL 2000 ends 12/31/2007.
We have a third party vender that do not currently support SQL 2005. Employee's data is transfered from our HR database to the third party database for the purpose of yearly performance evaluation on a daily basis.
Both databases are currenlty on a SQL 2000 server.
Can data be transferred from a SQL 2005 database to a SQL 2000 database?
View 4 Replies
View Related
May 17, 2007
I am reciving a new powerful database server
My old database server runs SQL 2000 and has the CRM 3.0 app and database, our corporate web site (SharePoint Services 3.0) database, and Project Server 2007 database. The corporate site and project apps and web sites reside on our file server.
I want to move, upgrade or migrate the databases, corporate site and Project site to this new SQL 2005 server. I am a little unsure the best way to do this.
Should I move all the database first, then move the apps?
Should I do a restore of everything on the new server, and after I know it works just turn off the other server?
Am I missing a better way?
Anyone have any insight, let me know.
Thanks,
Ken
View 1 Replies
View Related
Feb 23, 2006
I have been tasked with upgrading around 150 SQL Server 2000 DTS packages to SSIS in SQL Server 2005 standard edition. I made a backup of the 2000 database upon which the DTS packages operate and restored it to the SQL 2005 server. So far, so good. I have the database in place. Now I need to get the DTS packages themselves into the SLQ 2005 server. I think I need to check my install and make sure that I have the SQL Server 2000 DTS services installed on the SQL 2005 server. I can do that.
However, I wonder what would be the most effective way to physically get the packages from the SQL 2000 server to the SQL 2005 server. Should I use structured storage files? If so, how do I go about opening them in SQL 2005 in order to save them to SQL server 2005?
I should mention that these packages make heavy use of ActiveX scripting so I am looking at rewriting them from scratch to be SSIS packages. I just need the packages on the SQL Server 2005 box so I can make sure I am creating exactly the same functionality in 2005 as existed in SQL server 2000. Each DTS 2000 individual package tends to be fairly simple and I think I can greatly improve the process by consolidating them.
Thanks in advance for any advice.
S. Wells
View 3 Replies
View Related
Jun 7, 2006
Hi,
I'm a newbie on SSIS and am trying to grasp my way through this.
I am trying to copy data from a Sql Server 2000 database to a simplified table in Sql Server 2005 database.
What I want is to move the data to a staging table, then drop the main
table and rename the staging table to the main table, to minimize the
down-time of the data. I can't get the workflow to work, because the
staging table has to exist when I run the package. I thought I could
use an "Execute SQL" task to generate the table before I would run the
task, but that doesn't work. Am I going about this the wrong way? Is
there an optimal solution to this problem so my data can be accessible
as much as possible.
Regards,
Atli
View 5 Replies
View Related
Apr 28, 2006
I have a number of triggers that call a stored procedure that returns a cursor. The triggers then use the results of this cursor to do other actions.
My problem is that this works fine in SQL2000 but just won't work in SQL2005. When I try to access the results of the returned cursor, I get an error -2147217900 could not complete cursor operation because the set options have changed since the cursor was declared.
If I port the code contained in the sp into the trigger, it runs fine. But having to port over the sp's code defeats the whole concept of being able to re-use the sp.
Does anybody have any ideas of what could be going on?
I look forward to a quick response.
Dennis
View 8 Replies
View Related
Sep 18, 2007
Apparently you cannot go backwards. Once 2005 Express is installed, even removing it does not allow you to setup MSDE 2000 again. So there is no "trying it out" option.
Unfortunately, our software does not use 2005 Express. I tried it out, and now have a useless testing workstation that can't have MSDE 2000 installed again.
Any ideas on how to break the chain here are welcome.
View 1 Replies
View Related
Feb 7, 2007
I am moving from one physical server to another. I have a full working maintenance plan backing up the databases on the production server.
Is there a way to "script" / move the maintenace plan from the productiuon server to the new one easily?
thanks for help!
www.mirrorgate.com
View 2 Replies
View Related
Feb 9, 2007
hi, does anyone know how I can make a connection to a 2000 db thru ssis?
View 8 Replies
View Related
Oct 15, 2007
I have used backup and restore method to upgrage 2000 databases to 2005 database.
What do i need to do in order to for my application or users to use databse in 2005 and remove 2000
let me know
thanjs
View 3 Replies
View Related
Jun 7, 2007
hi ,
can any one help how to search on databases after user has entered some key words in random?
will be making front end in php.
View 1 Replies
View Related
May 22, 2001
I have started to install a 3rd party web-based product for our clients that uses SQL 2000 as its backend
However every time that they create a new 'topic' within the web app, it creates a new database, with a single table in it!! - There could/will be 1000's of these 'topics' created
I have told the company we buy this from that this is not acceptable - they have asked why!!
Can anyone point me in the direction of preferably a Microsoft document that I can send to them, as just saying 'you just don't do it that way' isn't working and I can't find anything easily myself
Many thanks
View 2 Replies
View Related
Mar 2, 2007
Hey Guys,
I do alot of development on my personal machine and have quite few databases in SQL Server. My PC is very prone to crashing :-p so Im writing a custom batch script to backup up all my data. How can I backup my SQL Server databses into a text file. I dont want to use the BAK file. In MYSQL this is a relatively simple process where i just have to use the mysqldump utility which scripts 'all' my databases (structure and data). Can I do the same thing in SQL Server? Please tell me a way. Its going to save me a lot of trouble.
Thanks in advance guys.
View 6 Replies
View Related
Apr 5, 2008
sql server 2000 .. harddrive problems resolved but now several of my datatbases have consistency errors.. lots of them.
best way to repair????????? need to get this resolved asap
View 3 Replies
View Related
Nov 22, 2006
I have just spent 2 days trying to rebuild my system databases after a crash.
Each time I issued the start /wait setup.exe etc. command, the task would fail with the error:
MSI (s) (80:10) [12:07:34:815]: Product: Microsoft SQL Server 2005 -- Error 1706. An installation package for the product Microsoft SQL Server 2005 cannot be found. Try the installation again using a valid copy of the installation package 'SqlRun_SQL.msi'.
The initial install of SQL was run from a network share. The rebuild was from CD.
It seems that the original installation source paths are retained in the registry and are not ignored when attempting a rebuild.
Searching the registry for 'SqlRun_SQL.msi' throws up
HKEY_CLASSES_ROOTInstallerProducts812B67BE5CF8FD14F9F1F73F0E443838
and
HKEY_LOCAL_MACHINESOFTWAREClassesInstallerProducts812B67BE5CF8FD14F9F1F73F0E443838
Resolution:
Under the HKEY_CLASSES_ROOT key, change the Sourcelist from network (n) to media (m) and <drive>:ServersSetup instead of the share
Also change MediaPackage under the Media key to ServersSetup
This will automatically amend the HKEY_LOCAL_MACHINE key
This allowed a successful rebuild of the system databases
Bring back Rebuildm!
View 5 Replies
View Related
Feb 15, 2007
Is there any speicial considerations when you prepare the maintanance Plan for the Search Database.
View 3 Replies
View Related
Oct 15, 2001
Hi,
All the maintanance jobs scheduled for weekend are still running after 66 hours.
1. transaction log backup
2. integrity check
3. complete backup
4. optimization job
I stopped the jobs from scheduled task lists, I can still see them running through current activity window.
Is it ok to kill them? Or how I can stop them?
Thanks,
Ann
View 1 Replies
View Related
Apr 29, 2004
Hi Guys/Gals,
Need some comments/ideas on the following scenario:
Current Situation:
-I have a PROD DB and a REPORTING DB( Separte Physical Servers).
-PROD DB replicates (Transactional) to REPORTING DB. ( Using only Replication Wizard to set up, quite easy)
-DB is for running shopfloor(manufacturing) applications, thus needs to be minimum downtime.
-Retention period for PROD DB data is 3 months ,Reporting DB is 3 years.
Future Problem that I will encounter:
-Purging of data in PROD DB will be replicated into Reporting.
-Schema change in PROD DB need to delete existing Publication before able to change schema.
-After schema change, need to recreate publication and rerun snapshot.
Questions:
-How to prevent the purging to be replicated to Reporting?
Switching off Replication when Purging takes place will not help. The only solution
I am thinking of is to alter the store procedure for replication during purging.
Is there any other "CLEANER" hassle free way?
- How to cater shema changes better?
Currently the data is not alot, but down the road, it might go to Terabytes, by then running a
snapshot will cost us alot. Is there any way not to redo a snapshot for this scenario?
Please give your comments/ideas/ .
Thanks.
View 5 Replies
View Related
Mar 28, 2007
Hello all,
I am working on an ASP.NET that different companies will be loggin on to. The way the SQL db has been written is that each company will have it's own database. However, I am not sure if this is the right approach since modifying the database would be quite a hassle (i'd have to modify each one). Is there a way a single databse would have several instances that share the same structure but with different data ?
What is the recommended approach in these situations ? Should I re-design the database so that ALL companies store their data in one huge database ?
View 5 Replies
View Related
Aug 21, 2007
Hello all,
I would like to be able to backup our databases to a network share mapped drive. Is this possible? When every I go in to setup a maintenance plan it will only allow me to select local drive as the backup location. If my server crashes its not going to do a whole lot of good if my databases are stored locally (I do also backup up to tape every niight). I backup the databases every hour to local disk and would like to send them to one of my MS Storage Servers on the network.
Any help would be greatly appreciated.
thanks
Jason
View 3 Replies
View Related
Nov 22, 2002
I have set up two Maintenance Plans to do daily backups overnight for our two DBs that are on our SQL server.
As a separate strategy we want to have a second backup done nightly that would involve
#1 detach the db(s)
#2 copy the mdf(s) and ldf(s) to L:xxx
#3 attach the db(s) again
#4 zip up the db(s)
#5 copy the files to a different server for storage.
I created #1, and #3 in query analyzer and saved the script.
I want the process to run at say 2AM and don't know how to schedule them to run - that is #1 ... #2 ... #3. Anyone have sample scripts for this kind of a backup strategy?
This seems like a very simple process especially for a restore and especially since there would not be any trasaction logs involved. This way if we had a KRASH we could take the backup from the separate server and install it on a warm SQL backup server.
Apart from the new servers name then what other steps would I need to cover to get the apps up and running in the quickest time. The app software runs as a client install - Access 97DB] I'm especially curious if I need to have more than a fresh MS2000 SQL server install.
I'm know I'm asking a lot for a first timer.
It seems we want to handle disaster recovery BEFORE we even have our first system crash.
many thanks
View 11 Replies
View Related
May 4, 2001
Is there any easiest way to move a 100 Gig sql 7.0 database to sql2000?
View 1 Replies
View Related
May 4, 2001
What is the easiest way to move a db of 100GB from 7.0 to sql2000?
any ideas
Rani
View 3 Replies
View Related
