We needed to replace our Motherboard on a server running win 2K Adv.
Server with SQL server 2000. After replacing, we could not bring
the system back with the previous OS. So, we have decided to
migrate to Windows 2003 server and install SQL svr on it.
On the old server, the SQL DB is residing on a seperate disk.
Is there any way one can install SQL on the new server and import
the data from the disk. Many posts talk about how to do detach/attach etc.
The case there is they have a running source server. In my case, I don't.
Hello, I'm in the process of moving a SQL Server 2000 to a new server. I have installed the new server added the latest sp. When I try to restore the system databases (Master, msdb) I get the following error "the database xxxx.bak Cannot be restored because it was created by a different version of the server restore database is terminating abnormally" I have looked at everything that I know of and both servers seem to be running the same versions of everything. Can I just export the databases the the new server? thanks in advance for any help you can give.
Hi, Everyone: We have two Domain T1&T2 that trusted each other's; one of SQL server of domain T2 has crashed. We rebuilt NT and SQL ver.6.5 with the same nameon the server of T2; we have the problem that crash server couldn't publish table to another server of T1. We got the error message:
08004(Microsoft)(ODBC SQL Server Driver)(SQL Server) Login failed-User: T2_sqlexec Reason: Not defined as a valid user of a trusted SQL Server connection.
Hi, i have a corrupt installation of SQL 7, so i am trying to attach the db's from that server to another, only it is not working. Is this soemthing that should be able to be done?
error message i get is:
Server: Msg 823, Level 24, State 1, Line 1 I/O error (bad page ID) detected during read of BUF pointer = 0x1159b2c0, page ptr = 0x205b6000, pageid = (0x1:0x9), dbid = 6, status = 0x801, file = C:MSSQL7Datacasenotes_Data.mdf.
I have been asked to move a system running MS SQL 2000 Server from a workgroup to a domain. The SQL server is running in SQL Authentication and the services are running as local system.
Will SQL Server break after the move?
Any advice will help. I thought I remember this being the case, but possibly only with Windows Authentication.
I need to move the SQL Server 2000 Desktop Engine (MSDE) database and all jobs to the SQL Server 2005 Enterprise Edition. - May I detach and attach the DB in my case? - Where is the procedure to move the jobs from MSDE to SQL Server 2005?
We have a SQL Server 2000 ent edition sp4 with 3 small databases and one 4 GB database which is REPLICATED The Server has been bouncing like a yoyo today because of a disk controller problem and I am preparing to move the Instance to a whole new server this afternoon. The new Server will have the same IP and name as the original server.
Any suggestions for the easiest or most seamless way to make this happen? preferably using Backup and Restore since they plan on taking the old server down completely and then building a new server with the same name and IP ... any suggestions would be appreciated.
Hi, paws. My server crashed recently, I didn't give to much importance because I knew that having access to the partitions I could recover my DB files and attach my database to my new server, and everything was fine until ... I found that my DTS Packages and Jobs where not in my Attached DB. Now, where can I find these ? Can you help a tormented man ? Thanks in advance.
We have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.
Is this even possible? I tried to move an existing Sql Server Express .mdf file to SQL Server 2000 by copying the .mdf file to the server's folder and then tried to attach it. I get:
Error 602: Could not find row in sysindexes for database ID 9, object ID 1, index ID1. Run DBCC CHECKTABLE on sysindexes.
I realize that I'm moving back a version in SQL, however the structure of the database is very simple. Does anyone know?
Even if I can just script the thing to SQL 2000 would be helpful, however the .mdf is a file within my ASP.Net site, and does not show up in my Microsoft SQL Server Management Studio Express under the appropriate SERVERNAMESQLEXPRESS either, so I can't figure out how to script it out?
Hi guys, I have tried to use the sp_help_revlogin script to move logins from a sql 2000 server to a sql 2005 server. It works for users that have a password. But if the password is blank it will fail. Is there a work around for this since I can't change the users passwords? I have also tried SSIS package but that too doesn't work because of the same reason.
how can we manage the db transfer when we are upgrading from 2000 to 2005? what is the right way to do that? where can we find something to read about it?
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Hi! I have created i webpage whos has a logged in system which is cretead in VS 2005 with the function ASP.NET configuration. And know will i move all databas to i a MSSQL 2000 there i only can have one databas, And know i have ASP.NET logged in Databas and one site databas. I just wondering if its possible to make i virtual connection with MSSQL 2000? If not somebody has some idés for me?
Is there a way to move the primary log file for a database to another drive without doing this with a restore database operation? I have added a second log log file but now I would like to delete the one that was created when the database was created.
I have an existing sql server 2000 installation on one server. I now need to take one 2000 DB and restore it to a new sql server 2005 installation (on a different server).
What is the best way to do this. I can not upgrade the sql server 2000 installation to 2005. Basically i hoping all i need to do is backup the 2000 db and then restore it on the new sql 2005 server.
I need to move our production database to a brand new machine on our LAN.Both machines are running SQL2K. I'd like to place the production databasein a directory on the destination machine with a slightly different pathname than the source SQL server.How can I shrink the transaction log to the minimum size before I try themove? What is the best way to move the database to the new machine? Wehave Veritus Backup Exec.Regards,Charles MacLean
Hello,I have a database in 2005 that I'd like to copy and attach in 2000. Is thispossible? if so, how do I do it? I've tried doing a number of things fromjust trying to attach to the db file to trying to export and import viaaccess and I can't seem to get anything to work.Any help would be greatly appreciated.Thanks!Rick
I have a MSSQL2000 box with a large database containing circa 150 SP's.I want to move the DB to another SQL machine, but many of the SP's havereferences to the name of the current machine. Is there any way tobatch edit the procedures to refer to the new server, disassociatingthe old machine completely?Tia,Graham
We have purchased a new Development SQL Server that is running SQL Server 2005. Our existing Development SQL Server is running SQL 2000.
How can I move the DTS packages from the SQL 2000 server to the new SQL 2005 server? I will be upgrading them to SSIS at some point, but don't have the time now.
I'm unsure what happened, but I'm using SQL Server 05 Developer Edition. I've been working with a local database where I tried to add a clustered index on a huge table (about 50M records). Well, I had to stop the query since it was maxing out my work computer. Since then, I've been unable to open the database or run queries against it.
When I open SQL Server Management Studio the database says In Recovery. Once it's done, when I try to expand tables, I eventually get this error:
TITLE: Microsoft SQL Server Management Studio ------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
i've got MS Windows Server 2003 OS (RAID 10) and MS SQL 2005, however server crashed with "blue death" screen. After forced reset, SQL server marked my db as a SUSPECT. Tried DBCC CHECKDB with no luck, what can i do to bring it back to life, please? (have no backup).
Msg 926, Level 14, State 1, Line 1 Database 'IRIX' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:182; actual 32:7602287). It occurred during a read of page (1:182) in database ID 5 at offset 0x0000000016c000 in file 'D:MSSQLIRIX.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. Msg 3313, Level 21, State 2, Line 1 During redoing of a logged operation in database 'IRIX', an error occurred at log record ID (844:9770:2). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database. Msg 3414, Level 21, State 1, Line 1 An error occurred during recovery, preventing the database 'IRIX' (database ID 5) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support. SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:182; actual 32:7602287). It occurred during a read of page (1:182) in database ID 5 at offset 0x0000000016c000 in file 'D:MSSQLIRIX.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. During redoing of a logged operation in database 'IRIX', an error occurred at log record ID (844:9770:2). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database. An error occurred during recovery, preventing the database 'IRIX' (database ID 5) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support. Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 824)
Recently moved a couple of dbs from SQL 2000 -> SQL 2005 (different machine). Just restored the dbs on the new server from a full backup of the old one. Everything is fine but...
Some queries are returning out-of-order results (for records added since the migration). I tracked this down to the indexes. I completely rebuilt and reorganized the indexes (online) through the manager interface. This helped provide correct ordering for existing records, but new records added since the re index are still out-of-order.
Looking for a way to permanently fix the indexes so I don't have to constantly rebuild them.
We have a new database server for SQL Server 2005. To use our old VS 2005 websites, which were connected toanother database server with SQL Server 2000, what should I do? Just change the server name of the connection stringin the Source code and/or Web.config? My preliminary testing seemed to be not effective.TIA,Jeffrey
Good day , Does anyone know how to moe / copy database users from sql server 2000 to sql server 2005. I ave been successful will everything except this in my migration. I can copy the database users themselves but not the users under the security section.
I just installed SQL 2005 on a new box. I want to move a database from a SQL 2000 server to the new server. Can I detach the database, copy it and attach it in the new server without having problems?
I'm concerned that if the datafile is in SQL2000 format, when I connect it to SQL2005 server, will it still be in old format or will it upgrade?....or is this something you don't worry about....and why?
We ran a test upgrade from SQL 6.5 to SQL 7.0. Everything worked great except we have one stored procedure (and it's an important one) which when run immediately after the upgrade, was fine. It ran in about 15 minutes which is normal.
However, when it was run the second time to retest it, it took 2-1/2 hours to run, then the third time it took almost 6 hours to run. There are no errors in the error log and I've used SQL Profiler to run on trace just on this stored procedure but it really doesn't show anything unusual except that it takes a long time to run this procedure.
The next step we took was to install SP1 thinking maybe there was a problem with a cursor, but that just seemed to make it worse.
Nothing else has changed. This stored procedure runs great on 6.5.
Does anyone have any clue why this might be happening. I dropped the procedure and recreated it, I've recompiled it, etc. and still the same results.
