Hi All,
I am new to sql server and the database concepts and just started learning. I want to copy a database and local package from a old sql server to a new server. can anybody guide me with the steps? I am very new to this field so if you could give me detailed steps i would very much appreciate it.
thanks in advance,
Hi,
I set up DB mirror between a primary (SQL1) and a mirror (SQL2); no witness. I have a problem when I issue command:
alter database DBmirrorTest
Set Partner = N'TCP://SQL2.mycom.com:5022';
go
The error message is:
The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy of the database log.
I have the steps below prior to the command. (Note that both servers' service accounts use the same domain account. The domain account I login to do db mirror setup is a member of the local admin group.)
1. backup database DBmirrorTest on SQL1
2. backup database log
3. copy db and log backup files to SQL2
4. restore db with norecovery
5. restore log with norecovery
6. create endpoints on both SQL1 and SQL2
CREATE ENDPOINT [Mirroring]
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ROLE = PARTNER)
7. enable mirror on mirror server SQL2
:connect SQL2
alter database DBmirrorTest
Set Partner = N'TCP://SQL1.mycom.com:5022';
go
8. Enable mirror on primary server SQL1
:connect SQL1
alter database DBmirrorTest
Set Partner = N'TCP://SQL2.mycom.com:5022';
go
This is where I got the error.
The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy
Thanks for any help,
KT
I'm using SQL Server Management Studio Express and I'm trying to figure out how to copy a table(s) from my local database to my web hosting database. I know how to do it in 2000, but it's completely different now. Is this feature not allowed on SSMSE? If so, then how do I deploy database tables to a web host?Also, how do you add local database(s) to SSMSE? I tried to use 'attach database' in SSMSE and it wouldn't allow me to navigate to My Documents folder where the database resides. Thanks...
View 8 Replies View RelatedHi all,
I'm having a problem right now. I'm trying to create an offline copy of a database(live) in my local machine. The database is maintained in a different server machine and I want a copy of the particular DB as an offline copy.
The problem is there's DTS feature in SQL Server 2000 but I don't find any such tool in SQL Server 2005 edition. Can anyone please guide me on how to do this process?
Thanks & Regards,
ThunderRock
Hi and thanks in advance for your help.
I have a dilemma and I need some expert help with this. I am trying to make a copy of a remote Database and then replicated the DB and it's contents on my local machine so I can build a test site to run data with. I tried to remot into the server machine but I guess that feature is not allowed by the honest of the remote machine. Since I build on my local machine and would like to be able to test data on my local machine.... I would like to copy the remote DB to my local computer and then I can run my test app on my local server. The version of SQL on the remote machine is SQL Express 2005 and I have SQL 2005 on my machine. Please give me how to accomplish this please.
Dollarjunkie
hello all,
I am using vb.net in windows form. I have made a module which is connected to sql server 2000.
Now, I want to have a fresh copy of the remote database of SQL Server at my local computer and whenever there is change in remote database(insertions,deletion or updation), my local database copy may gets synchronized(i.e changes get reflected in this local copy).
Can any one help me? If it is possibel by using Vb.net code, it is very well, and if there is some Sql Server wizard that can help me do that, please reply to me.
Thanks in advance.
I lost my database on my pc as I format my hard drive. Now, how I can get a copy of my ms sql server database from my hosting to work with my local pc? I need to have a local copy so that I can develop my site without internet connection. For your information, I used Hostforlife.eu hosting service. I have searched and tried many methods to do it, but no luck yet. For example, I created a backup on Hostforlife.eu and restore backup file on my pc, but nothing happens. Then I created a new database, and re-created its structure same as the one on Hostforlife, then I used the import wizard to import data from them to my pc. Again, nothing happens.
View 5 Replies View RelatedHi there.
Here is my problem: I'm trying to copy a few tables from an ODBC database located on a PC on my LAN to a SQL Server on a remote server.
To do this I have created a DTS package on the SQL Server which runs smoothly, copying the data as it should, but only as long as it copies the data from the ODBC database on my own computer where I have Enterprise Manager installed. The moment I try to copy data from another PC in the network where Enterprise Manager is not used to execute the DTS package the task fails to run.
I'm quite at a loss here and would very much appreciate a notch in the right direction. Perhabs some source or book which I may read to solve the problem.
/Bakkegaard
Hello,
I'm trying to migrate a SQL 2000 database to SQL 2005. I'm using the Copy Database Wizard and can copy the database using the detach and attach method, but I would rather use the SQL Management Object method. I get the following error when trying to use this method:
Package "ShellPackage" failed.
This error occurs directly after the following step:
Event Name: OnInformation
Message: Transferring data to database RestoreTest from RestoreTest
Operator: <WANfirst.lastname>
Source Name: BP-BLM-TESTSQL2_BLM-JCAMPVSSQL2_Transfer Objects Task
Source ID: {E6765B9E-1B40-49ED-B0CE-F99252AA34B6}
Execution ID: {213272C4-37E9-4A1E-A5B9-A2F9A61348B3}
Start Time: 12/20/2005 3:05:58 PM
End Time: 12/20/2005 3:05:58 PM
Data Code: 0
The database is created successfully but the data is not transfered. Also, the logins are created on the new server successfully. Has anyone seen this error or have any ideas on how to solve this problem? I would greatly appreciate any help!
Thanks,
Joseph
I try to copy database from remote SQL Server(6.5) to our local
SQL Server(7.0). I try this way: First, in Enterprice Manager,
I try "NEW SQL SERVER REGISTRATION" using "Register SQL
Server wizard". The remote server give me the IP, login name
and password. then, I try connect option by "login using
SQL Server". But I got message say:"specialted server not found,
Connection open,create file". some times say:"client server access
denied..." some times say:"timeout". What's going on here?
So, I can not get going on with "Import data wizard".
Does anyone know how to solve this problem? Any answer would be of great assistance!
Thanks
I am trying to
copy a database from our company's external SQL
Server(production) to our local SQL
Server(development). The Copy Database wizard fails on the step
"Execute SQL Server Agent Job".
Following is the error in the log file.. Please advise
InnerException-->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)
Hi all
Could someone tell me how I create a local copy of an existing database on my machine.
Thanks
Hi,I have copied a MS SQL database to my local machine and am testing itwith ASP pages, locally, on IIS. I have a db connect page that keepsthe current connections for the live database. My question is, as thelocal db is named 'local,' is there another name I need to give it andthus call from the connection page?Also, when copying a db, are the permissions (username and pass)copied over with it?Thanks,Louis
View 1 Replies View RelatedHi SQL folks,
I've googled for this the whole yesterday and I couldn't find a complete solution.
I'm having a sql2005 database in my development machine and I need to copy all the content "Tables, Diagrams, PK columns and other data" to the remote production machine.
Using the Import/Export method didn't copied the relationships between tables, also it turned the PKs into just a standard columns
Can anyone help?
Hi,
I am trying to test a replication or at least get the feel for it on my local copy before I set it up on the real server.
Can I do that by setting my local database as the publisher as well as the subscriber?
I am getting an error message but I am wondering if there are any settings I can change to make this work. Or any other ideas of how to see the replication tool before actually doing it live?
Error message:
"Server 'MyComputerName' is neither a Publisher nor a Distributor, or you do not have permission to access replication functionality on this server.
I might add that I am not only new to the project but also new to MS SQL Server.
Thank you!
I created my database on a remote server. It now has lots of tables and stored procedures
When I created it, the server created a schema named for me, the user, so all my tables and stored procedures are named like johndoe.tablename.
I would like to rename the schema to something less personal more professional.
Can it be as simple as "ALTER SCHEMA johndoe RENAME professional"?
Also, I would like to create a local copy of the databse, so I can develop offline, without the 2 second delay.
SQL Server Management Studio Express lets me generate scripts, which I have been using to make backups.
Can I use the script file to recreate the database on my local machine?
Thanks
We currently have a PPTP connection set up for our developers toaccess our development SQL server through a VPN tunnel. When theyneed to copy tables up to the dev SQL from their local machine theysimply do a DTS copy.However, we are now moving to a thin client solution where they willbe working on a terminal server. They will have access to thedevelopment SQL servers and SQL tools such as EM and QA. However,they will not have access to their local SQL server and, therefore,will not be able to directly perform DTS copies. We have exploredseveral possibilities such as exporting tables to a .csv or .mdb fileand then importing them on the development SQL server but this is notideal because things are lost in that process (e.g. primary keys,field names, data types, etc.)My question is this: Is there a way to export and then import SQLtables without losing dependent objects such as primary keys and datatypes in the process? If any of you are working with a similarsituation I would really like to hear how your remote users copyobjects from their remote location to your SQL servers. Thanks!Ryan--Posted using the http://www.dbforumz.com interface, at author's requestArticles individually checked for conformance to usenet standardsTopic URL: http://www.dbforumz.com/General-Dis...pict211310.htmlVisit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=722630
View 4 Replies View RelatedI have installed the Workstation components on my local PC, which also contains VS 2005 and SQL Express. I installed the WS components so that I could run the full blown version of SQL Management Studio from my PC, to remove SQL 2005 servers.
I tried to update the Workstation components to SP1, but the SP1 package stops at the Setup Support Files, step and terminates claiming the package does not support SQL Express. I realize the package is not intended for Express, I simply need to update Management studio.
I tried running the Post SP1 Tools hotfix and it complains that it will not update SP0 of the tools.
I have successfully updated Express to SP1 and applied the Post hotfixes as well. Is there any way to patch just Management studio on a system with Express installed?
Thank,
Jim
I am facing a problem in connecting to the local database with server name as (local).
I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.
if anyone can help me what is the problem in this case it is highly appriciated.
Hi Everyone
I am at the stage of architecting my solution
My goal is to develop the system on a windows application and pda
There is a central server which will create a publication called inventory
The laptops which host the windows application will be subscribers to the central server using merge replication
The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server
I have been reading for days and I am still unsure whether this is possible to do.
I know Appforge provide a conduit for palm to access synchronization but not local sql databases
I would appreciate your help immensley
I am in a situation where I need to get a copy of test database that ison production server running MSSQL 2000 Standard to my local machinerunning MSSQL 2000 personel. I tried to use the copy wizard where itappears I get connected to the source server OK but when I try toindicate the destination server which is my local machine I get errorspoping up about cannot connect to (local) etc.I am NOT a DBA just a programmer trying to get a local test environmentup to be more productive.Lsumnler
View 2 Replies View Relatedhello
I have the following problem with a local dts package which I created with a domain adminuser (domainadmdba) and runs ms oledb for oracle to execute access for a oracle database. thereafter the data fills up into a sqlserver table, this runs as local package perfectly. if i place the package into the scheduler and run the dts-job with an another domain user (domainsrv_sql=service account) i get connecting problems. the service account (domainsrv_sql) has sysadmin right in sqlserver and local administrator right on the operating system. which right must the service account possess, so that he has the necessary right to execute this dts package?
single dump from the log file:
with admdba:
The execution of the following DTS Package succeeded:
Package Name: DTS__000000006
Package Description: Import CUSPERS from ZMA
Package ID: {E13C874F-4ABF-11D5-92A4-0008C70D8D6E}
Package Version: {768B2A40-4ECE-11D5-92A4-0008C70D8D6E}
Package Execution Lineage: {9FCF25E5-4ED1-11D5-92A4-0008C70D8D6E}
Executed On: xxxZS270
Executed By: ADMDBA
Execution Started: 22/05/2001 6:44:58 PM
Execution Completed: 22/05/2001 6:45:09 PM
Package Steps execution information:
Step 'Delete from Table [HELPDESK].[dbo].[cuspers] Step' succeeded
Step 'Copy Data from Results to [HELPDESK].[dbo].[cuspers] Step' succeeded
with srv_sql
The execution of the following DTS Package ?succeeded?:
Package Name: DTS__000000006
Package Description: Import CUSPERS from ZMA
Package ID: {E13C874F-4ABF-11D5-92A4-0008C70D8D6E}
Package Version: {768B2A40-4ECE-11D5-92A4-0008C70D8D6E}
Package Execution Lineage: {AF7B9D41-4ECF-11D5-92A4-0008C70D8D6E}
Executed On: xxxZS270
Executed By: SRV_SQL
Execution Started: 5/22/01 6:30:00 PM
Execution Completed: 5/22/01 6:30:00 PM
Package Steps execution information:
Step 'Delete from Table [HELPDESK].[dbo].[cuspers] Step' succeeded
Step 'Copy Data from Results to [HELPDESK].[dbo].[cuspers] Step' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error
(Microsoft OLE DB Provider for Oracle (80004005): The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 (or greater) client software installation.
You will be unable to use this provider until these components have been installed.)
Step Error code: 80074005
Step Error Help File:sqldts.hlp
Step Error Help Context ID:1100
Thanks for any help !
Greets Indio
I have a fairly large DTS package which processes a large amount of data and outputs it to a series of tables. Currently I am saving the package as a local package, but I want to save it as a file to make migrating to different servers easier for the people who will be moving it. My question is, Can I run the package as a file without saving it as a local package on the server? And if so, are there any good examples of how to do it out there?
View 1 Replies View RelatedIs there a way to run a local package from a stored procedure?
Thanks,
Ken Nicholson
I'm getting errors from time to time saving DTS changes as local package. I'm using SQL 2000. I've got sysadmin role.
I know there were DTS package ownership bugs in SQL 7 - but I thought these had been cleaned up with the latest SP.
Any suggestions would be appreciated.
Hello,
if i have a given database (a model) and i want to copy this database in the same database instance. Is it ok to copy the mdf and ldf file and attach the files with a new database name in the same instance.
Or is the datebase name part of the .mdf file?
Regards
Markus
Being a very novice SQL Server administrator, I need to ask the experts a question.
How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?
Thanks,
Rick
I have a Local DTS Package that I created that runs fine. I have scheduled it to run daily but it errors out when run it from the agent. This is an excerpt of the error from the Job history.
Delete from Table [Intranet].[dbo].[Employees] Step, Error = -2147217887 (80040E21)
This Local DTS Package, deletes the records in the file and reimports the data from an AS400 file that is recreated for me daily.
The only thing that has occured to me so far is that perhaps the SQL Agent Service Account needs permission to delete the records. (I'm using NT Security).
Am I on the right track or do you think it's something else?
Hi all...
Error when trying to schedule a local DTS package.
Package Error message is...
Microsoft SQL-DMO (ODBC SQLState 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.
Can anyone help please...
Thank you in advance
I create a local package in DTS a few months ago. And set a schedule to run daily. Now i need to modify. How to read the content of DTS local package? i try to right click the package in job, and edit, but i didn't see the content. How can i see it and modify. Why mine can't be read? Thanks.
View 4 Replies View RelatedIs there a way to print the source code from the local package. I know you can go in the source and cut and paste it into a word document. I was wondering if there was a way to do it when you are in designing the package so that it would print all the source codes of SQL statments/queries.
View 1 Replies View RelatedHi,Did anyone successfully set up a local package to first ftp a db.bakand second perform an automated db restore?I need to perform an automated task, which ftp nightly backup file toanother server and then restore onto a database and leave the databasein read-only mode for additional transaction logs restore during theday.Can someone help and provide the procedures on how to do that?Thanks in advance.
View 1 Replies View RelatedDeal All:
I have got a strange problem on runing SSIS package, please help me.
The package contains a Script Task which function is downloading files from a SFTP server with using psftp command line application. It will run successfully with using dtutil.exe and as a job with using a ssis execute proxy(domian account as credential), but fail runing the package as a job with using a ssis execute proxy(local windows account as credential, although has Administrator permission).
It seems a permission problem, but I try a lot and can't solve it.
Would you kind give me some suggestion ?
Thanks a lot.
Tomorrow