Migrating Sql Server To Another Drive
Jan 16, 2003I would like to know the 'best' way to migrate an existing S2K server database from the 'C' drive to another drive on the same machine.
Thank you
ADVERTISEMENT
Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive
Jan 31, 2008Being 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
SQL 2012 :: How To Backup Half Of DBs From A Server On C Drive And Other Half On D Drive
Jan 16, 2015How to backup half of dbs from a server on C drive and the other half on D drive and vice versa, first half on D drive and other half On C drive using only one job and one stored procedure??
Using scheduling from job add 2 schedules to the job so first schedule backup first half to C and second half to D , the second schedule backup first half to D and second half to D.
Can I Used A Shared Drive Rather Than A Mapped Drive With OpenRowSet?
Apr 4, 2008
Hi
I have been trying to use openrowset with a shared drive, and even though the share has "full control" permissions granted to "everyone" and the accout that SQL runs under has been granted explicit full control permissions I am unable to open the file which itself has no security on it.
Can I not use a \ path and only use mapped drives?
Thanks
below works...
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:5People.xls', [Sheet1$])
below doesn't work...
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=\cluster02FileManager5People.xls', [Sheet1$])
How To Move A Log File From 'e' Drive To 'f' Drive....
Nov 9, 2000I am trying to move a log file from one drive to another.
What I have done is add another file to my file group. So now my log has a file on the 'e' drive and one on the 'f' drive. I now want to remove the file on the 'e' drive. I have emptied the file on the 'e' drive. When doing the command:
ALTER DATABASE Uniprodruntime
REMOVE FILE m_rk_runtime_log
I get the following error message..
Server: Msg 5020, Level 16, State 1, Line 1
The primary data or log file cannot be removed from a database.
I have also gone into enterprise manager and tried to delete the file and it does nothing.
Has anyone run into this?
SAN Drive Speed Vs Local Drive
Feb 12, 2007How do you compare SAN drive vs local drive on a 32 bit server?
Is it good idea to move my DB files to a SAN instead of local?
Canada DBA
TempDB Keeps Getting Filled And It Is In C Drive But It Should Be In T Drive
Nov 28, 2015Server: SQL 2008 R2
1: TempDB keeps getting filled. Restart of the server has not fixed it. I shrink it, but the space gets filled again. Now I can't even shrink it anymore
2: TempDB is at the wrong location. Its current location is this :C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLPROD6MSSQLDATA empdb
How do I change its location?
C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLPROD6MSSQLDATA empdb
Correct location of TempDB should be: TempDB(T:) But its not there
Problem Occurs When Migrating A SQL Server 2000 Database To A SQL Server 2005 Server
Sep 20, 2006When I try to migrate a database on a SQL Server 2000 server to a SQL Server 2005 server with the Copy Database Wizard of the SQL Server Management Studio, I'm confronted with the following problem;
Performing operation...
- Add log for package (Success)
- Add task for transferring database objects (Success)
- Create package (Success)
- Start SQL Server Agent Job (Success)
- Execute SQL Server Agent Job (Error)
Messages
* The job failed. Check the event log on the destination server for details. (Copy Database Wizard)
When I take a look at 'Event viewer' on the SQL 2005 server, the following error is displayed;
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)
I already enabled the MSSQLSERVER network configuration protocols (TCP/IP and Named Pipes ).
How do I solve this problem?
Migrating Sql Server
Mar 8, 2008I've developed a website and it's hosted by a hosting company. Lately i've registered a new domain with a new virtual hosting account. I've transfered my web files succesfully. But migrating the sql server failed for a couple of times now. My database containes many tables with many products. My hosting provides doesn't give me the opportuniy to restore my backup which i've backuped from my old server. First I tried to use the import and export tool of sql server 2005. This was very easy and it succeeded. But this tool only migrates the tables and the views. All the common stored procedures of asp.net membership are not exported. So I can't login at the moment. I've tried to generate a sql script with all the stored procedures with sql server management studio. But If i want to run this script on my new db, it fails with various errors. I tried to use the aspnet_regsql tool to create all the membership tables and stored procedures. If this succeeds, I can import and export my old db to the new one. But i'm getting a error while trying to use the aspnet_regsql tool. The error number is 290 and the error is: How can I fix this? Er is een fout opgetreden bij het uitvoeren van het SQL-bestand InstallMembership.sql. Het SQL-foutnummer is 290 en het SqlException-bericht is: Invalid EXECUTE statement using object "Relation", method "SetUseVarDecimal".----------------------------------------Details van fout----------------------------------------SQL Server: Database: [samet]Geladen SQL-bestand:InstallMembership.sqlOpdrachten mislukt:/*************************************************************//*************************************************************//*************************************************************/DECLARE @ver intDECLARE @version nchar(100)DECLARE @dot intDECLARE @hyphen intDECLARE @SqlToExec nchar(400)SELECT @ver = 8SELECT @version = @@VersionSELECT @hyphen = CHARINDEX(N' - ', @version)IF (NOT(@hyphen IS NULL) AND @hyphen > 0)BEGIN SELECT @hyphen = @hyphen + 3 SELECT @dot = CHARINDEX(N'.', @version, @hyphen) IF (NOT(@dot IS NULL) AND @dot > @hyphen) BEGIN SELECT @version = SUBSTRING(@version, @hyphen, @dot - @hyphen) SELECT @ver = CONVERT(int, @version) ENDEND/*************************************************************/IF (@ver >= 8) EXEC sp_tableoption N'aspnet_Membership', 'text in row', 3000/*************************************************************//*************************************************************/IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'aspnet_Membership_CreateUser') AND (type = 'P')))DROP PROCEDURE dbo.aspnet_Membership_CreateUserSQL-uitzondering:System.Data.SqlClient.SqlException: Invalid EXECUTE statement using object "Relation", method "SetUseVarDecimal". bij System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bij System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bij System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bij System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bij System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bij System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bij System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bij System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)
View 2 Replies View RelatedMigrating To Different Server
Jun 27, 2001Hello!
We are planning migrating to different server.
I know the answers how to migrate all jobs and DTS packages.
But the only question I have is "How to migrate logins and passwords?"
What is the best way to transfer logins?
Can't you just export syslogins table into text file and then import it into the new server?
Thank you
Lena
Migrating To Sql Server 7.0 From DB2
Apr 22, 2000HI all,
Could any one pls suggest me, how i have to migrate to sql server 7.0 from db2. Pls also recommend some sites where will i get the information regarding this migration.
Thank you all.
---Chowdary
Migrating Access To SQL Server
May 4, 2004We use MS Access 2000 as our database, but run into lots of proplems. So we decided to research the migration to SQL Server.
I used Access Upsizing utitlity to migrate tables and their data to SQL server very easily, and all the relationships, indecies and other information are converted correctly.
Next is to migrate the queries. I found that to be a pain. Is there any tool out there that can do it for me? Any help is greatly appreciated.
Once that's done, then it's the application itself, but I am not worrying that for now.
Thanks, guys
Migrating To Different Server Part II
Jun 28, 2001I have another question regarding migration process to diffrent SQL Server.
Last time when I did migration I didn't restore system databases (master in particular).
I only restored user databases and of course I've got login errors such
Microsoft SQL-DMO (ODBC SQLState: 42000) Error 15023: User or role '%s' already exists in the current database.
I just used sp_change_users_login to fix those orphans.
I've read articles in MS knowledge base and not quite sure is this a good idea to restore master database prior to restoring all user databases on the new server in order to keep all logins?
I'll try to use recommended article for transfering logins with password instead of restoring master database from backup
http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP
Any advice is greatly appreciated.
Lena
Migrating 6.5 Database To A New Server
Mar 19, 2002I am migrating MS SQL Server 6.5 databases to a new server and wanted to create the data & log devices differently than they are on the old box. My dbcc checks are giving me 2558 errors because my devices weren't built the same size in the same order. I thought if I didn't copy the master, I didn't have to rebuild the database exactly the same. Can anyone tell me if there is a way to rebuild different device sizes and do a successful restore ? Thanks in advance !
View 1 Replies View RelatedMigrating From Oracle To SQL Server
Feb 6, 2003I have a program that uses ADO to read/write to/from an Oracle back-end database. I'm hoping that given the underlying schema is the same, I can simply change the database driver I'm using and use a SQL Server database instead. Has anyone migrated an application using ADO from Oracle to SQL ? Are there any issues/problems/tips that I should be aware of ?
Thanks in advance..
Scott..
Migrating All Database To A New Server
Apr 10, 2003I need to move all existing dbs to a new server. One of the database is over 90GB in size. If I plan to use to restore database option, should I restore all user database first, then the system databases(master, msdb) or should I restore the system database first and the user databases second??
Thanks.
Migrating SQL Server Database
Sep 18, 1998Hi!
I got a project of moving a web site of one a firm from one ISP machine to another ISP
machine. They are using Cold Fusion with SQL Server as the database. I am new to SQL Server.
I want some tips on how to migrate the database from one machine to another.
Any little help will be appreciated.
I will be waiting for suggestions.
Mark.
Migrating From SQL Server To MySQL
Aug 4, 2004Hello, anyone knows a good way to export a data base from MSSQL Server 2000 to MySQL? Any suggestion is accepted. Thanks
View 3 Replies View RelatedMigrating From RMS Files To SQL Server
Sep 5, 2004Hi,
I will migrate data from a legacy COBOL system to SQL server 2000 Database.
OS: Open VMS
Data storage: RMS files
Any of you has any useful information or links related to this subject?
Thanks,
Migrating MySQL To SQL Server
Nov 5, 2005What is the difference between the SQL used in MySQL and on the MS SQL 2000 server?
Can anyone recommend a good reference on translating a mySQL dump to a format that could be easily uploaded to a MS SQL server?
Thanks!!!!
Migrating To SQL Server 2005;
Dec 15, 2005Hi all,
I have a Database in SQL Server 2000 with several objects (tables, views , stored procedures , functions ).
Is there any specific procedure or tool by which I could migrate the entire database to SQL Server 2005.
Any help would be appreciated.
Thanks,
Hari Haran Arulmozhi
Having Some Issues Migrating To A New Server
Mar 3, 2004The Setup: I'm moving a SQL Server 7 Database from a SQL Server sp'd somewhere between 3 and 4 (7.00.1028) to a SQL Server without any service packs. The old machine is a Dell PowerEdge 2400 (about 3 years old) and the new machine is a Dell PowerEdge 2650 with dual gigabit nics (and I have them teamed). Both machines run Windows 2000 Server. Mostly default installation on both the OS and SQL Server.
The Problem: When I restore the database to the new server (and resolve the orphaned login issues, etc.) the server hangs unbelievably. Most of my users can't even connect, much less work in their vb apps. I can ping the machine, but can't run the simplest T-SQL against it.
Any ideas?
Help would be greatly appreaciated.
Migrating Users To New Server
Aug 31, 2007Hope somebody can help a novice, so I can impress my boss.
I've got to move a database to a new server and I'm trying to use Gregory A Larsen's sp_help_revlogin script http://www.databasejournal.com/features/mssql/article.php/2228611.
It works perfectly for all users, but I want to limit it to one database by using his suggestion shown on that page:
SELECT sid, name, xstatus, password FROM master..sysxlogins
Your_db..sysusers b on a.sid = b.sid
WHERE srvid IS NULL AND name <> 'sa'
However, when I make the changes, so it looks like this:
SELECT sid, name, xstatus, password FROM master..sysxlogins a join
int_test..sysusers b on a.sid = b.sid
WHERE srvid IS NULL AND name <> 'sa'
I get this error when I try to run it:
Server: Msg 209, Level 16, State 1, Procedure sp_help_revlogin, Line 12
Ambiguous column name 'sid'.
Server: Msg 209, Level 16, State 1, Procedure sp_help_revlogin, Line 12
Ambiguous column name 'name'.
Server: Msg 209, Level 16, State 1, Procedure sp_help_revlogin, Line 12
Ambiguous column name 'password'.
Server: Msg 209, Level 16, State 1, Procedure sp_help_revlogin, Line 12
Ambiguous column name 'name'.
Can anyone see what I'm doing wrong.
The database that I want to limit the script/procedure to is called int_test on the same server, and I've checked that the table sysusers does exist, and that it has a column called name.
Any help would be greatly appreciated.
Paul
Migrating Data From DB2 To SQL Server
Aug 4, 2006Hello,I am trying to migrate data from a DB2 database to SQL Server 2005database. Does anyone know about any migration tool that does that? Ihave heard about DB2 Migration Tool kit, but I think you can onlymigrate data to a DB2 database with that. Thank you.Sincerely,Eldhose Cyriac
View 2 Replies View RelatedMigrating From Excel To Sql-server
Jul 20, 2005Hello,I have got the job to migrate data from an Excel-sheet to asql-server-database. I have a lot of experience with Access butSql-Server is not in my line.So who can give me some advice about how to do this job?thanx for your help, Helmut
View 1 Replies View RelatedMigrating SQL Server 7.0 To 2005
May 18, 2006I am in the process of migrating from [Source] SQL Server 7.0 sp4 on windows NT to [Target] SQL Server 2005 on Windows 2003 Server.
Please suggest me what should be the migration approach it this case.
Would De-attach and attach of DB still be valid if OS changes? (both are 32 bit OS).
regards
Migrating Server Instance
Jan 3, 2008Hello. I am using the built-in SQL Server 2005 Express edition which comes bundled with Visual C# 2005 Express and found that, apparently the separate download of SQL, i.e., 2005 Express Edition with Advanced Services SP2 offers more features.
I wanted to know the following.
Can I somehow migrate the instance of SQL Server Express bundled with Visual C# to SQL Server 2005 Express Edition with Advanced Services SP2?
Or is there a way to have my IDE tie into the other SQL Server natively?
I would like to be able to write distributeddeployable C# applications which can connect to the more full-featured SQL if possible.
Thank you for any suggestions
Migrating To A New Server In A SAN Environment
Jan 18, 2008 Hi,
We currently have a SQL 2000 server setup with the data and log files (including those for the system) placed on a SAN. Our current server is old and starting to have problems so we are transitioning to a new server. I just wanted to see if anyone has done this before or if my plan makes sense.
1) Hook the new server into the the SAN Arrays holding the data and log files.
2) Take the old Server off-line, and bring the new one up.
3) Point the Master db to the location of its data and log files.
4) Restart the server.
In theroy, since the master "knows" where all of the other databases are located when the it starts the recovery process it should bring up all of the other databases on that server. Does this make sense or am I missing something?
Thanks in advance for any help!
~Jeff
Migrating Reporting Services From SQL Server 2000 To SQL Server 2005
Mar 31, 2008
Hi,
I'm migrating SQl Server Reporting Services from 2000 to 2005.The reports are generated normally in 2000 but it seems that it is taking more time in 2005 or sometimes it does not generate the report at all.Could you kindly suggest a solution?
Thanks,
anne
Migrating MS-SQL Server 2000 To MS-SQL Server 2005 For Web Application On .Net Framework 1.1
Aug 10, 2006Hello,
I have to do an impact analysis for migrating a .Net web based application. The current and desired scenarios are mentioned below.
The current environment:
OS - Windows 2000, SP4
Framework - .Net 1.1
SQL Server - MSSQL Server 2000
Desired Environment:
OS - Windows 2003, SP1 / Windows 2003 R2
Framework - .Net 1.1
SQL Server - MSSQL Server 2005
Please let me know
1. If any changes need to be done in the application when migrating the database from 2000 to 2005?
2. Any relevant document which will help me in the same.
Regards, Venkat
Migrating SQL Server 2000 Stored Procedures To SQL Server 2005
Dec 20, 2007I have successfully moved my data from a SQL Server 2000 hosting site to a SQL Server 2005 hosting site. I Made a backup of my database using Enterprise Manager (2000) and imported the database tables using SQL Server Management Studio (2005). I do not know how to move the 25 or so stored procedures that I have in SQL Server 2000. I have a very short amount of time to figure this out and am hoping that someone can give me a brief step by step answer on how to get this done. I would appreciate any information you can provide. Thank you!!
View 5 Replies View RelatedMove Sql Server From One Drive To Another
May 14, 2001I need to move Sql of the C drive on a server to another drive. Any Ideas.
Thanks Brett
Sysbase Drive For SQL Server
Feb 7, 2002I am running a Win2K Professional and SQL Server 2000. I also installed Sysbase on my pc. I tried to import Sysbase database from SQL Server 2000 manager but I could not see Sysbase ODBC driver. Does any body know how can I get the Sysbase ODBC driver.
Thanks.