I'm a beginner user. I'd like to move the whole database from a work station to a server, how should I do it in a safe way? First of all, I have a very basic question: How could I save a database in SQL Server? Thanks in advance.
Dear All,We have a procedure that takes12 minutes to run on the first server butthat same procedure now takes 3 hours to run on the second server using thesame data. Does anyone have any suggestions why this is happening and howto make the procedure faster on the second serverThanks in advance.Jeff Magouirk
hello everyone. i am new to the group so i aplogize if this question hasbeen answered recently...our sql db machine is too old. we bought a new server with which to replaceit. the trick is, we want to keep the name of the machine and db instancethe same.obviously, we don't plan on having two machine with the same name on thenetwork at the same time. how do we handle this?my first thought is to name the new machine with a new name (mach2),transfer over all the db's, take the old one (mach1) off of the network.rename the machine/instance to the old one (mach1).if i do this, can i drop the original instance on the new machine(mach2)-->register the new (mach1)? will my data be there?Thanks so much for any relplies!!!
SQL Server 2005, when moving a machine to a different domain and changing the hostname the logins such as domainSQLServer2005MSSQLUSER$hostname$MSSQLSERVER are still showing the old hostname and domain name. Does anyone know what impact this has on the system and also if there is anyway to update these accounts without reinstalling SQL Server?
Hey, I have copied a C# express edition project from another machine and have opened the project up and changed the connection string but the project is not updating the database when I try to insert values from textboxes in forms. They seem do be getting into the dataset but not the sql datatabase. I am getting alot of messages saying that it could not find the schema information for the dataset. Could these errors have anything to do with the project? What else do I have to change in the project?
I am moving my SQL 2000 Server from a Small Business Server to a full version of Windows 2000 Server and SQL 2000 Server. I have had no experience doing this but have backed up and restored my production databases for practice in case a of disaster situation. Is there anything special I need to do to move everything, including the system databases to a new server and not loose any of the user logons, etc.?
I have a bunch of SSIS packages that were created on a 32-bit machine (OS as well as SQL Server) where they run without error. I have moved them to a machine with a 64-bit OS as well as 64-bit Enterprise SQL Server, SP2. Initially I encountered errors with the packages that contained Script Transformation tasks where I had to set PreCompile=True. This allowed me to execute the packages individually. When I try and execute them as a batch, I encounter errors on various packages. They don't seem to be consistent - sometimes the error occurs on one package, the next time it will be on a different package. Sometimes they occur pre-execute, sometimes post-execute. Here are a couple of example errors:
[OLE DB Command [1007]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". [Insert Destination [1177]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ".
The source database is on a different server, but the destination database is on the same server as the SSIS packages for testing purposes. Any information would be appreciated...
Hi everybody. I have such problem: After I move my integration services packege to another machine it failed. I tried to recreate connection manager, but result is the same. If I create a simple SQL task in that package and try to execute it - it fails with info:
SSIS package "Main_Package.dtsx" starting.
Error: 0xC00291EC at Execute SQL Task, Execute SQL Task: Failed to acquire connection "SRV-DSA3.TIA_EXTRACTS_OriginalData.sa". Connection may not be configured correctly or you may not have the right permissions on this connection.
Books On Line makes breaking out the report server databases on to a separate machine from the report server itself sound very easy. I have tried it and it is but I can't get the report server to connect to the databases once they are on the other machine.
Everything was done by the book(s). We use SSRS only for intranet use so all inside firewall. The SQL Server 2005 services on both machines (including the RS Windows service) all run as the same domain administrator account, this account was used to log in to RS Config Tool and it was told to use this account under Windows Authentication to connect to the database server. The two machines are in the same domain, even on the same switch. The only difference is the one with report server on is Windows 2000 Server SP4 and the one to which the rs databases are moving is Windows Server 2003 SP1. The account mentioned above has sysadmin rights on both SQL Servers, as well as having all the RSExecRole rights as specified in BOL. And it has rights to logon as a service in group policy on both machines. Its password hasn't been changed.
The RS Config Tool completed fine and reported no errors.
But when you try to connect to the report server you get the error:
"The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed)" The log shows that a privilege required by the client is missing but doesn't specify what! I thought this was all taken care of when the RS Config Tool told it which account to connect with.
This is driving me daft. It should be so easy!! Does anyone have any idea what might be wrong? Nothing says I need to do anything with the encryption key when I am keeping the report server itself exactly as it was and just moving the catalog - or have I missed something here?
Hi everybody, I moved my packages to the new machine, and have problem with parent variables. When child package tries to get parent variable value I get an error:
Information: 0x40016042 at LoopPackage: The package is attempting to configure from the parent variable "MAIN_SesId".
Warning: 0x80012028 at LoopPackage: Process configuration failed to set the destination at the package path of "Package.Variables[User::MAIN_SesId].Properties[Value]". This occurs when attempting to set the destination property or variable fails. Check the destination property or variable.
Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA
I want to install only the Reporting Service (and Analyzing Service) on a machine without any database (I will create a dedicated SQL Machine later on). Now, after the installation process I can see a SQL Server in my Installed Programs View. To me this looks like a complete SQL Server installation,but this is not what I wanted (I only checked the two services during the Setup). Or are those just some supoorting components?
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
Help! I am using Script Transformation to output a new column as image[DT_IMAGE] field to store serialized object. In the VB script, the sample code as
The package always runs fine on my developing machine and will halt on other machine at AddBlobData after certain number row records were processed. I am stuck here. Anyone has any suggestion?
What I need is reading data from mutiple tables in one database and writing into a single table in another datable. In order preserve all the columns data, I use input column fields to construct a new object and then serialize it, and store the serialize data into detination db table. (The object and serialization function is coming from c# dll.)
Dim b As BusinessLicense = New BusinessLicense() b.ApprovalDate = Row.approvaldate b.BusinessId = Row.busid b.BusinessName = Row.busname b.NaicsCode = Row.naicscode b.NaicsDescription = Row.naicsdescr b.OwnerName = Row.ownername b.Phone = Row.phone b.Pkey = Row.pkey b.RenewalDate = Row.renewaldate b.StartDate = Row.startdate b.Suite = Row.suite
Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line Row.infoType = BusinessLicense.TYPE
Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06
Hi to everyone, I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.
Hullo all I have two machines, One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ? running the procedure as a Domain user results in a failed job/stored proc. also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ? please e-mail me at wayde@sunnygrp.com if you have any thoughts...
I am using SQL Server 2005 Management studio. I already created a database including the table with stored procedure. Now, I want to copy all my database data, including the table and stor proc into my laptop. How I can do that? How I can save my database data in management studio into external drive (pen drive or external drive) then tranfer into my personal laptop? Please help... Thanks
I have a backup file in SQL Server 6.5 on machine A and wish to restore the database on another server on machine B but I cannot figure out how to do this...There is not enough room on one machine for both the database and the backup file and I cannot seem to be able to create a backup device on a different machine. ... ... HELP.
Hi, I have two servers, namely ServerA and ServerB. These two servers are on the same subnet. ServerB has a database called DatabaseB. I'm logged in in ServerA and trying to pull data from DatabaseB.
This is the query I do when I'm logged in in ServerB (note im using Microsoft SQL Server Management Studio):
USE DatabaseB
SELECT distinct b.Subject FROM dbo.F_Class_Exam a LEFT OUTER JOIN dbo.D_Course_Catalog b ON a.Course_ID = b.Course_ID WHERE a.Term = '2071' AND a.Class_Exam_Type = 'FIN' AND b.Term = '2071' ORDER BY b.Subject
How would I do this same query on ServerA? Ideas? Thoughts?
How would I copy an entire database to another (using a differentname, of course) on the same server? I am new with working withdatabases, so any help would be appreciated. Thanks.
Im guessing this is the right forum for this question:
I have a database on a WS2003 box running on MSDE 2000. Were trialling SQL 2005 (currently running on Win XP pro) so what i would like to do is to "copy" the database from the WS2003 box to the XP SQL box. So we can evaluate the database and see what SQL does/doesnt do.
1. How can this be done please?
2. Will it do anything to the original database?
3. Can this be scheduled to be done everyday? if yes how please?
Hi I want to transfer a database from one PC to another. (Both running SQL Server 2005 express) I have copied the files (SQL Server Database Primary Data File and SQL Server Database Transaction Log File) from the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData folder of the source PC to the destination PC (Same folder). I was under the impression that using Microsoft SQL Server 2005 - SQL Server Management Studio Express these files would be picked up and could be used, do I infact need to do something to attach the files/database so that they will appear in SQL Server management?
I have an SQL database running on an old server and i am upgrading the server, but i am having some problems moving my SQL database over. Has any one got a work through they could mail me to give me a hand!!