Moving SQL2k To New Appliance

Jan 16, 2007

I am moving a SQL 2k database from a Windows 2000 server to a Windows 2003 server (seperate appliances) and would like as little SQL downtime as possible.

I have several applications that I believe are connecting to servernow by servernow€™s name and don€™t want to have to figure out how to change them to servernew. Would it work if I built servernew and copied/moved the SQL database to servernew, then take servernow off line and change servernew€™s name to servernow?

I am open to any suggestions on other more appropriate methods.

Thanks in advance

Melonheads Sister

View 5 Replies


ADVERTISEMENT

Headaches Moving An SQL2K Database Between Servers

Jul 20, 2005

Greetings all,This should be an easy task, and Im sure it is, but as many times as I havetried, I cant seem to get this to work properly.We changed ISPs recently from a shared host to a co-located server, and ourformer host was nice enough to send us a backup of our old SQL2000 database(about 5MB).I went into Enterprise Manager, created an empty database with the same nameand used the Restore Backup tool successfully. I took a look at the db andsaw all the Tables and data intact.Next I wanted to re-create the DSN to match the old one so that I wouldnthave to fiddle with any of the old connection strings in my asp pages.Thats where the fun began. The old DSN was created by our host via an emailrequest and I never got a look at the actual creation process of that DSN.I created one on our colo server with the same name, but it would only passthe connection tests when I used the Windows User Authentication rather thanSQL Server Authentication. No big deal I figured, and just went ahead andset it up using the same DSN name.Next I tried the main.asp page to test the DSN and lo and behold I got theODBC connection errors. I tinkered with the connection strings a bit andmanaged to get a wide variety of connection errors and fine-tuned to thepoint that it said "Unable to login with user 'SERVER169/nacog'". At thispoint, I went into Enterprise manager and added 'nacog' to the User list andthe connection string no longer produced errors. (By the way, my connectionstring simply contains "DSN=YAVAPAICONNECT;")My next step was to actually execute a SELECT statement which produced thefollowing error:Microsoft OLE DB Provider for ODBC Drivers error '80040e09'[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied onobject 'ADMINS', database 'YAVAPAICONNECT', owner 'dbo'./nacog/admin/main.asp, line 189Why was I not surprised?I went back to Enterpise Manager, saw the all the tables had 'dbo' as theowner, and tried to give 'nacog' all the permissions at the table level, butthe error persists.To preserve my sanity I stopped there, because I spun my wheels for hoursand days the last time this happened. and my eye has not stopped twitchingsince ;)I am quite sure that this has something to do with one or all of thefollowing:1) The way SQL2K was installed (it was installed by someone else)2) My creation of the db with the windows login, rather than SQL auth, priorto import3) My creation and handling of the DSNMy background is mainly in ASP programming, and I understand bits and piecesof this puzzle, but for the life of me I cannot piece this thing together.Can anyone help point me in the right direction or suggest a good tutorial?I would be very thankful to anyone who could help put me on the right track.Best Regards,Ben M.

View 1 Replies View Related

Moving A SQL2K Publisher To A SQL 2005 Instance.

Sep 30, 2005

Hi,

View 17 Replies View Related

Moving Text File Properties For Sql2k Dts To Sql25k Ssis Packages???

Jun 2, 2006

Hi everyone,

We€™ve got almost 250 old dts packages which simply loading data into Sql tables from plain files or at the reverse point. Most of them are defined with fixed fields and its fixed positions one after one. We don€™t want to migrate them using Import wizard, on the contrary we€™re producing them from the beggining taking advantatge of SSIS architecture to the full.
And now, we€™re trying to imagine how to migrate automatically that valuable info from Sql Server 2000 to Sql Server 2005 without efforts€¦ You know, any program be able to move that detailed info
to SSIS.

So we would avoid to select again all these positions per each file -very tedious and we're lazy


I don€™t see how except, of course, migrate them directly

Let me know if you need further explanations or more clarity on that.

View 5 Replies View Related

SQL On Appliance Edition

Feb 2, 2007

Is it possible to install and run SQL server on Windows Server 2003, Standard, Appliance Edition? The operating system came installed a storage server.

Thanks!

View 1 Replies View Related

Enterprise ETL Appliance

Feb 7, 2007

At least one company has developed such a product. Here's a link: http://www.dataintegrityinstitute.com/copula.htm

I am interested to read your thoughts on this.

DISCLAIMER: I don't work for the aforementioned company and don't benefit from them in any way.

View 3 Replies View Related

Can Msdb From SQL2K Personal Edition Be Restored On SQL2K Standard?

Oct 12, 2007

The company for which I work did not have a DBA until I started a few weeks ago. Whoever installed SQL2K used the wrong CD so they have been running Personal Edition on their servers. I have installed a new SQL2K standard instance and have restored everything except the jobs and DTS packages. Can the msdb from the Personal edition be restored to the standard instance?

View 3 Replies View Related

Downgrade SQL2K Enterprise To SQL2K Standard

Mar 15, 2007

Is it possible to downgrade SQL from Enterprise to Standard Edition, or do you have to remove the previous installation (uninstall) and reinstall. Meaning you would also have to restore all user databases? Thanks.

View 1 Replies View Related

Transact SQL :: How To Get Moving Total Like Moving Average

Nov 10, 2015

I trying to get the moving total (juts as moving average). It always sum up the current record plus previous two records as well and grouped by EmpId.For example, attaching a image of excel calculation.

View 3 Replies View Related

Excel To SQl2K

Nov 30, 2001

Hi,I am having a problem in moving data from execl to sql2k.
The data looks like 16.70% , 12.5% etc and when I move it it changes to 0.16700000000000001 etc..
any idea what datatype I should use so that it don't changes it's mode...
Thanks in advance

View 1 Replies View Related

Installing Sql2k

Apr 6, 2001

Hi,
I am new to sql 2k.
Iam been asked to install sql2k on a new box .
What all things I should keep in mind when I go for the installation of sql2k?
Any / All suggestions appreciated.
Jai

View 3 Replies View Related

From SQl7 To Sql2k

Apr 6, 2001

Hi,
I have to move 2 fields from sql 7 to sql 2k .
the field is text.
feild a is text
field b is text.
I have to add field a and field b and move it to another field (say field c which is also text )in sql 2k.
How to go about it?
TIA.
Jsi

View 2 Replies View Related

Timeout In SQL2k

Jun 23, 2001

I moved my DB from SQL7.0/NT to SQL2k/WIN2k.
Everything was fine from the last few months but suddenly I start getting timeout errors.
I checked and rebuild all the indexes - there are no deadlocking at all - everything looks quite normal to me - I am all lost now as what to monitor and where to see for this timeout error messages.
Anyone has any idea as what is going on what should I check to see if that's the cause.
I also ran Profiler but there too nothing too long as to timeout.
My sql box is attached to IIS box and pager is set on IIS box.
The problem is not with IIS box cuz when I shift the applications to another SQL box everything runs fine and there is no timeout messages.
Any thoughts appreciated.

View 2 Replies View Related

Restoring SQL2K% To SQL 2K - Possible?

Jan 23, 2007

I have been sent a backup file from a supplier that I have been trying to restore. I have succesfully installed it on my SQL2K5 instance, however, we need to put it on our SQL Server in our DMZ . . . Which is running SQL2K . . . Supplier was informed of this and says that you can restore to a SQL2K DB as long as you use SQL Management Studio . . . Tried that and got an error message Saying That Restore Headeronly is terminating - Too many backup devices specified. . . only 64 are allowed. . . .Supplier suggests that its a SP4 issue . . . Installed SP4 and tried again . . . Got the Same Error again (SQL Server Error :3205)

Am I out of my gourd I am sure that restoring a SQL2K5 Backup to a SQL2K instance is not possible?

I should say that I am Running SQLExpress as my 2K5 Instance and MSDE as my 2K instance . . . Before I invest more time on this and trying it on a development server running Standard edition.

Thanks All

--
Regards
Tony The DBA

View 4 Replies View Related

Sp_addlogin (SQL2K)

May 9, 2008



Hello,

I am trying to script out a new login in SQL 2000. I can script the login, but I am trying to assign the correct permissions, (e.g. db_datawriter, db_owner) and I am have trouble scripting the permissions. Here is a snippet of what I am looking to accomplish in my script. Remeber, this is 2000 not 2005...

-- This works
exec sp_addlogin @loginame = 'LoginName'
,@passwd = 'Password'
,@defdb = 'Database'
go

-- This doesn't. I am not even sure if this is what I need...
exec sp_addrolemember @rolename = 'AdminCVB'
,@membername = 'db_owner'
go

View 3 Replies View Related

SQL2K Login Issue

Aug 31, 2004

hi,

i'm hoping somone can shed some light on why this isn't working. basically i have a webform which that passes data back to a database (SQL Server 2000) and uses Windows authentication to perform the UPDATE, INSERT, whatever.

i've defined a role within the database, specifically for the application. for my tests, i've added a global security group from my Windows domain to the logins on the SQL instance. this group has been added to the custom role in the application database.

since i'm a member of this global security group, i was under the impression that my credentials would pass through and everything would be ok, however, it's not recognizing my login - or others in the group as well.

the application web (in IIS5.0) has been set to Windows Authentication, and i've flagged the impersonate=true attribute in the app's web.config file.

lastly, my connection string for the sqlconnection object grabs my user name (or the current user for that matter) in the format of DOMAINaccount. for the sake of argument, i was able to successfully connect using a custom SQL login that was assigned to the custom role.

the error that's returned specifically states that the "Login failed for DOMAINaccount"

any thoughts on what's up here? i guess i'm not understanding SQL Server security to well. thanks in advance.

View 1 Replies View Related

Restrict Access To DB On SQL2K

Nov 12, 2001

Hi,

Is there a way to prevent new users from accessing a SQL2000 db (like to put it into DBO mode) while leaving current users finish their running jobs.

I tried Alter Database and sp_dboptions and both in SQL2000 requires to close all current users. It was working in SQL7 but not in 2000.

Thanks

AAA

View 3 Replies View Related

Register SQL2k From SQL7

Apr 6, 2001

Does any body know if it is possible to register SQL 2000 server from SQL v7.0 enterprise manager.

Thanks

View 5 Replies View Related

SQL7/SQL2K On Same Box: Compatable As 6.5/7.0?

Jan 4, 2001

I don't have any extra machines, so I'm thinking of evaluating SQL2K on one of my existing boxes with SQL 7 already installed. My experience is that SQL 6.5 co-existed extraordinarily well with SQL 7. Does the same apply to the SQL 7 / SQL 2K combination? Thanks!

View 1 Replies View Related

SQL7/SQL2K On Same Box: Compatable As 6.5/7.0?

Jan 4, 2001

I don't have any extra machines, so I'm thinking of evaluating SQL2K on one of my existing boxes with SQL 7 already installed. My experience is that SQL 6.5 co-existed extraordinarily well with SQL 7. Does the same apply to the SQL 7 / SQL 2K combination? Thanks!

View 3 Replies View Related

Transaction Logs In Sql2k

May 24, 2003

I am new to sql2k
previously i used to work with sql7

how do i clear the transaction logs in sql2k

pavan

View 2 Replies View Related

Encryption/decryption Sql2k

Sep 17, 2003

I am planning to use XP_CRYPT for encrypting and decrypting cc#'s, passwords etc., at database level. Any suggestions or experiences on this. More info about this product at
http://www.activecrypt.com/faq.htm

View 12 Replies View Related

SQL2K Bind Failed

Jun 11, 2004

I tried to install SQL Server 2K on a W2K server running IIS and SSL. The SQL installation failed until I deleted the certs from my system. Now, the SQL logs say "SuperSocket Info: Bind failed on TCP port 1433". I have tried everything on the MS KB, TechNet, and MSDN sites that I could find. I have also uninstalled IIS and Certificate Services from the server. Since there are no certs left, I suspect that SQL Server is getting in it's own way on startup. Does anyone know of a way to trap/log this kind of conflict?

View 14 Replies View Related

SQL2K: Deadlock On Lock

Sep 10, 2007

Hello,

I have scheduled a job using Job Agent in SQL2K (Management). Every once in a while i get an error when i view job history:

Executed as user: xxx. Transaction (Process ID 53) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.

The process ID changes for every error. Sometimes its 51, 56, or 54 as well.

I have checked several times, but there is no other process that runs at that time. I even rescheduled it for a different time, but even then it fails about once every week or two.

How can i check what is the other procedure it is deadlocking with, if it is? OR what exactly is the problem, if it is not with any other process?

Any help and/or guidance is much appreciated.

Thanks,

J

View 4 Replies View Related

EM Won't Connect Locally On SQL2k Box

Jan 24, 2002

Here is a strange one. Have a sql2k box that I upgraded from 6.5 back. Conversion went fine, everything was ok with the sql install. Created and scheduled maintenance jobs while logged on to the box. A few days after the conversion, Enterprise Manager cannot register the server(error message is 'Data source name not found and connection libraries do not exist'). This inablilty to register the server only occurs when working on the server itself. You can register the server while connecting from another box with EM.

So, do some checking and find that the box itself does not recognize SQLSRV32.dll (etc) as even existing on the box BUT IT DOES EXIST in the normal places, it was a working install just a few days prior. As far as the box is concerned, the network libraries do not exist. Therefore, cannot register the server locally, cannot create a Data Source using the SQLSRV32 driver, cannot start the Sql Server Agent(so no scheduled back ups, etc).

Went so far as to re install the connectivity and client tools, which did not fix the issue.

Does anyone have any ideas?

View 1 Replies View Related

Installing A SQL2K Cluster On W2K

Jan 26, 2002

I am trying to configure a 2 node SQL cluster. MSCS is configured and is failing over correctly, however when I start the installation of SQL Server, and specify the IP address of the virtual server and hit next, the installation hangs, and stops responding. I have configured MS DTC and verified that it shows up in the cluster administrator. I am not sure what else to do, please help.

View 2 Replies View Related

SQL2K Memory Upgrade

Apr 8, 2002

We are running SQL2000 on Compaq 8500, want to upgrade the RAM from 4GB to 6GB. What do I need to change in SQL in order to see the more memory?

We want to leave only 1GB for the OS and the rest for SQL2K.

Thanks

View 1 Replies View Related

High Usage Of RAM On SQL2k

Dec 30, 2005

Hi

I have an sql server with very high usage. The web which is connected to the sql server has approx. 1000 unique visitors every time.
The database is optimized and the site goes really fast now.

But a problem we've had since the beginning is that SQL Server constantly uses 1.8 GB of RAM. Never less, never more.

Do you have any idea on how to decrease the usage of RAM. I am sure that this high usage is necessary.

View 4 Replies View Related

SQL2K - Database Restore

Apr 16, 2004

Hello,

I had a peculiar problem yesterday with SQLserver2000 database restore from one server to the other. I copied the .BAK file ( 11.2 GB) from source server to target server. Target server already had the same name database. I use SEM to do restore the database using the disk file .BAK as source to restore. The NT drive space was 13.5 GB available after copying. Restore failed with an error that not enough disk space is available to restore and it needs 23 GB of space for expansion. What does it mean? The database went into "Loading" state and it got corrupted. I tried to drop the database and cleared the DBF and LDF files on the drive and again tried to restore from .BAK file but it failed again with the same error message that not enough space is available for expansion. Now I do not have the original database or am not able to build the new database.

Finally I did attach/detach methods where I could bring back the database in running state.

What is it complaining about not enough space? Why did it ask for almost 100% more space for some expansion in restore process?
Why it did not fail when doing attach/detach methods from other server.

Any valid explanation is appreciated.

Vinnie

View 2 Replies View Related

SQL2K On W2K3 Cluster

May 8, 2004

Hi All,

I have installed a dual node active passive W2K3 Clusters with SQL 2K.
The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs.
How do I put the Transaction logs on the RAID1 disk as at install SQL2K only asks where you would like to put the SQL data ?

Any tips appreciated.

View 2 Replies View Related

Accessing SQL2K Using MS ACCESS

May 3, 2007

When I access SQL2K using ODBC (linked table manager), I am not able to display any data. The columns show #Deleted as their data values. How do I display data in ACCESS from SQL2K tables?

View 18 Replies View Related

Push Data Into Sql2K

Sep 18, 2007

Hi, all,

I did not see this one coming, and I am not sure if I did something wrong.

How do you push data from sql05 to sql2k?

I set up a data flow task, with one sql05 connection magager and another sql2k connection manager. Then when I tried to map them, I cann't!

The message on the box said: The connection manager uses an earlier version of sql server provider. Bulk insert operations require a connection that uses a sql server 2005 provider.

I have been trying different source, destination and transformation, but seems like missing something.

Thanks!

View 3 Replies View Related

Importing Sql2K Db Into Sql2005

Dec 5, 2007

Hi,

I tried restoring a sql2000 database into sql2005 but the import failed. Is it possible to do a import like this or do you have to do some kind of db conversion?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved