I would like to know what is the best way to move all the data from a DB to a new database. Some of the tables has different names, and attributes, so is there a way to create a script or something that will do that.
Both databases are in the same server.
How do you move a database from lets say E drive to G drive on the same server? Any ideas.
Regards,
I’m working with an msde database on my local machine, but need to take that database and move it to my remote host. This is problematic because I can not just do a back up and restore.
I was wondering if there were any asp.net applications that would generate lots of sql statements to reproduce the database on my remote host.
I had built a program to back up all the tables in that way, but, forgot that the membership stuff uses stored procedures, and I don't not know how to modify my program in order to back those up too.
Any help will be much appreciated, thank you very much for reading my post
Hello,
What is the easiest way to move a database from one server to another with the all table structures, view and stored procedures?
Thanks,
Can someone tell me how to move the log file for a database from one drive
to anoyher. I want to keep the data on one drive and the logs on another
so I need to move the log files to another drive.
Thanx, Kelly
Without restoring the database, has anyone written a slick little piece of code that moves a file existing on on filegroup to another newly created filegroup without doing it from a restore.
The purpose of doing this is to get rid of one data file and placing the data into the data file we are retaining. We have some more physical file space and are moving data into one data file and one transaction log file.
We have already ran the DBCC SHRINKFILE with EMPTYFILE to move the data,
We have already ran the ALTER DATABASE statement but here, because the filegroup is identified as PRIMARY in the sysfilegroup table, we can not REMOVE the data file because of indexes relating to the PRIMARY filegroup.
So if I could ALTER DATABASE and create a bogus filegroup and move the data file which I want to get rid of into the bogus filegroup, I could ALTER DATABASE with REMOVE filegroup and solve the situation.
Does anyone know of an easier way to do it other than BACKUP database and RESTORE database.....please help!!!
Thanks,
Daimon
Using sp_detach and sp_attach we can move different databases to different locations.
how do we do the same for system databases such as master,model,msdb and tempdb.
As off i know we got to be in master database to runthis command, if not this how do we go about this.
Thanks,
sheena
We will move t-log from one disk to another one. I tried Alter Database and found it did not work for log.
Can somebody give me a method about moving log from different disks?
Thanks.
Jean
I read the one of the replies to a question.
"Subject:
From:
Date: SQL 7 Restore (reply)
Manish (manish45@yahoo.com)
11/1/01 9:03:43 AM
If you want to move all the databases to new server. Stop the SQL server service on existing server. Copy mdf and ldf files of all databases to same location iin new server. Also take the backup of master and msdb database from existing server. Then restore master and msdb on new server.
"
My question is how to move my database to a DIFFEREN LOCATION on a different server. My two servers are different file layout (not my choice though.)
Thanks a lot in advance.
Wuchun
P.S. Should I use the DTS at all to perform this task?
Hi:
I need your suggestion or experience about how to move a database from SQL 6.5 to SQL 7.0. The server where SQL 6.5 resides locates in different network than SQL 7.0. DTS does not work for the database move because of two server can not talk directly.
We need to do this task very soon in production environment. I tried to backup database to a disk (backup device in SQL 6.5) but I failed to restore it in SQL 7.0 because the backup file was not detected by restore utility in SQL 7.0.
Please tell me what I should do. Besides BCP, are there any other methods to move the database from SQL 6.5 to SQL 7.0 in diffferent networks.
Thank you very much.
Joan
Does anyone know how to move the transaction log(s) of a LIVE database to a new location. I must move the log of a database to a new mirrored drive without any disruption to users. I cannot take the database offline or use the sp_detach_db stored procedure. Your inputs are much appreciated!
View 1 Replies View RelatedHow do I move all the databases to a new drive in the same machine?What effects/problems will be?
Thanks!
Hi
I am new to sql server 7 and dont know how to 1.make a copy of a database
and 2 to move a database i know there are sys stored procedures but the syntax looks crptic and i dont know where to type them in if any one could give me any really clear examples of how to do both of the above i would be really grateful, thanks!
What's the easiest way to move a 7.0 log file to a new physical location?
View 2 Replies View RelatedHi there,
Does anyone know how to move tempdb (mdf and ldf files) to another physical disk of already instaled SQL Server 2000? (The idea is to move the tempdb to another dedicated disk in order to improve the performance.)
Regards,
Azv
Next month client is moving servers to new location. The servers will get new ip and subnet Our user db's which are on a SAN will be moving to new SAN. My plan is the following, please correct any mistakes.
1. Do full backups of everything
2. Detach user db's
3. Copy these files to usb box (100 gig worth)
4. After server is in new world bring it up
5. Copy db files from usb
6. Attach db files
We have to recut two NT Servers that have SQL 6.5 on them. After recutting them and installing SQL 6.5 I will recreate my devices and then my Databases. If I use the sql dumps to restore the data bases
should I import my logins through the SQL Security manager first and then restore the dumps. If someone has done this or has a better approach it would be great help.
Need to know proper procedure for moving our NT/SQL 6.5 server to new IP subnet. Re-IP'd the server, moved and fired it up SQL Server gets:
DBLibrary - Server is unavailable or does not exist...general network error.
What needs to be done at the SQL level to complete the move?
Thanks.....
i've got to move 37 SQL Server databases over to new server. My manager tells me that i have to conduct some "check totals" to make sure that the databases contained exactly the same data from what it was when it got moved.
Is there some stored_procedure to do this ? to make sure that all the stored procedures, views, tables got move across ?
Hi gang,
Just trying to get some information on what is required to migrate from Access 2000 to SQL Server?? Is it pretty difficult to do? Are there any changes to the data or structure that is needed? Is SQL Server more secure? What about MSDE instead of SQL?? I'm just needing some tips and info on what to expect and all as I think we are going there kinda soon. I can do many things in Access but not sure how to go about them in SQL Server? Can you also do reports from there as well?
Inquiring mind wants to know
have a nice one,
Bud
Thanks in advance!
I have several jobs (most scripted in activeX) that I need to move to a different server. Is there an easy way to "copy and paste" them from one server to the other? (SQL7 to SQL2k)
SQL Nubie need to accomplish two things. 1. backup an SQL2000 db on old hardware. 2. Use backup to build same SQL2000 db onto new hardware, which will replace old hardware as main system. Running Win2000 server standard edition on old server and Win2003 server standard edition on new server. Old server does not have a tape backup, but it has a cd burner and access to a Novell corparate network -without any established Windows domains. Asking for much, hope someone can help. Some source material would go along way. Thanks
View 1 Replies View RelatedHi,
I'm new to SQL Server. How do I port the modifications of my table structures, store procedures, functions on the staging server to the procduction server without affect the data?
Can I make this modification to production database while user are still accessing the database or I have to bring down the database to make these changes?
Thanks in advance,
Hi,
I'm a C# developer, not a DBA, but fairly familiar with sql server 2000 and learning 2005. I have a need to update a table on one sql server from another remote sql 2005 server. Both will be SQL 2005, but will not be on the same network, so there will be firewall issues to contend with. Security is not a huge concern as the data is public info and not personal secure information or anything like that. What I'll have is a table of data in one sql database. I will have a copy of that data on another sql server that is used at an ISP and drives a web site. I need the table at the ISP sql server to get updated from the SQL server that is onsite in our office on our private network. I would like to not have to get network admins to open sql server ports if possible, so I guess I'm wondering if there is an easy way with SQL 2005 to update data from one sql server to another in the environment that I have described that maybe could expose the data over a common port (ie port 80). I don't want to have to use integrated security as I'm not sure this would work between remote databases in this scenario. I don't know if the web service end point support in sql 2005 would allow this. The examples I have seen online show a sql endpoint created and then accessed from a .NET application. I can do that if I have to, but I would rather do all of this inside the database in some fashion. I am open to any idea that would work and if I need to, I can ditch the idea of using something over port 80 and can get the necessary ports open between the sql servers. This is a pretty simple scenario that we have with one table of data needing to be updated weekly on a web based sql server from a remote sql server.
Any ideas on how you would approach this would be greatly appreciated. Security for the data I'm accessing is not a huge concern as the data is public domain as I've said, but I need to make sure the rest of the server and database on both ends are secured.
Thanks for any help!
Is there a way to move database from developement to production servers along with the logins and their associated roles as well as passwords. I did backup and restore and used sp_change_users_login to fix the logins
I mean is there a way to copy logins and roles Thanks
I have a db that I created on my local machine and need to move it to our server. The problem is that I created it with sql server 2005 express and our server is a sql server 2000 so restore and attach don't work. I don't have management studio (just express) so I don't know what I need to do to move it. Any help is appreciated.
Thanks
I am having problem moving packages/solutions for one folder to other.
Is there any specific way that we have to do this.
I copyed a solution and pasteditin a shared folder and when i open it iam geting connection errors and package correpted errors.
i amy sound funny but pls can any of you tell me the procedure.
thanks
Can anyone tell me if it is possible to move the data directory of SQLServerfrom the application server where SQL runs to another system (the file andprint server) in the network?regards Joop
View 1 Replies View RelatedI'm needing to move a database from SQL 7 to SQL 2000. What is thebest way to accomplish this and keep all tables, data, permissions, etcin place throughout the move.Should I use BCP, Replication or something else?Thanks for any help.
View 2 Replies View RelatedI am in a 2 Database shop (DB2 and SQL Server) in which one of ourlarger clients use Log Shipping.We have need to tune a table on the primary server and ADDED a simpleindex to a table.Will that index be replicated down to the secondary server via logshipping. Or do I need to stop log shipping and apply the index to thesecondary server?Thanks in advance for the help.Sincerely,Mike
View 1 Replies View RelatedHiWe have a SQL 2000 (sp3) server with a database that I set up to have theMDF on D: and the LDF on E:. All was going along fine for several months andone day the server rebooted. The SQL log says something like "Service isshutting down due to server shutdown."When it came back up the LDF File was on D: (in the same folder as the MDF).The original LDF was gone from E:The SQL Log doesn't ever say anything like "Recreating LDF in defaultlocation." or any anything else that would explain what happened.I assume the change happened during the reboot (actually I didn't notice ituntil a week and a half later). I am relatively sure no human did anythingthat caused the log file to move.So has anyone seen this happen before.?TIA-Dick
View 1 Replies View RelatedAm MS Access 2000 DB To an SQL SERVER 2000?(without Enterprise manager)
View 3 Replies View RelatedI need to provide justification of moving from 32 bit 2000 to 64 bit 2005
Are there any white papers/testing results on this specifically?
Ian