Urgent: Help Moving The Databse To A New Server
Mar 12, 2002
Hi
We are planning to move the sql 2000 database to a new server. These 2 servers are not going to be on the network at the same time, due to network identification problems.
We have to move a database to this new server. I know that detaching and attaching the databse logins are not copied. To use the sp_linked server option is not possible since these 2 servers are not up at the same time.( Is this correct? )
Is the backup and restore only my option for doing this? or any other easy methods exist?
Please suggest the better and safe way to do this. They are planning to do this at the end of the day.
Thanks in advance.
Padma
View 1 Replies
ADVERTISEMENT
Oct 5, 2000
I have been trying to move dts packages from one server to another server. I used the DTSBackup Utility to backup all the packages. The restore will not work.
If you know how to transfer Packages please let me know.
Thanks
Jacqi
View 2 Replies
View Related
Nov 15, 2000
Is there any easy way to move users between SQL Servers for a particular database?
We have tests and development servers I would like to make sure the user lists are in sync for that db.
Thanks
View 1 Replies
View Related
Nov 4, 2005
Hello,,
I backed up my database and it created a BAK file. Now I move this file to other server and trying to restore from it. It is giving me error: Device activation error. Do I have to create database before restoring. I do not have this database available in other server and I need to copy database with all constrains and tables.
Thanks,
View 2 Replies
View Related
May 22, 2008
Hi all,
I am planning to restore of a SQL 2000 Database on another server
can you folks tip me in the right direction with the SQL script to be used.
any help much appreciated
Much thanks in advance
Josephine
View 5 Replies
View Related
Jun 20, 2007
I am using " Microsoft.SqlServer.Management.Smo". I am trying to attach a database using the AttachDatabse method in it. but it is not working for me.
I am pasting my code as follows...tell me the problem or the right way to do it....
SqlConnection Connection = new SqlConnection("Data Source=SHEBZ; User ID=sa; Password=sa");Microsoft.SqlServer.Management.Common.ServerConnection con = new Microsoft.SqlServer.Management.Common.ServerConnection(Connection);Server ser = new Server("SHEBZ");
ser.ConnectionContext.Connect();
System.Collections.Specialized.StringCollection File = new System.Collections.Specialized.StringCollection();File.Add(@"D:Project-PartsMasterPageOfficeUploadsDb3");
try
{ser.AttachDatabase("Db3", File);
}catch (Exception ex)
{Label1.Text = "ERROR: " + ex.Message.ToString();
}
View 2 Replies
View Related
May 30, 2008
Hi,
Recently we upgraded the SQL sever from 32 bit box to 64 bit and we encounterd some weird results like data was not refreshing unless we manually does a manually refresh.
we just ran some migration scripts from another server to the new 64 bit server and script is correct only thing problem is with data refreshing.
Please send me the solution for the problem and let me is there any script that we can refresh the database using tsql command???
Thanks in Advance,
Shiva.
View 2 Replies
View Related
Aug 1, 2007
Ok so I have a SQL server database set up and I can't figure out how to create the spot where the user's login password should go and also what the specifics of the password column should be.....and yeah....all help is appreciated
View 3 Replies
View Related
Jan 10, 2006
Hello everyone,
I am working on a project for a professor. The project entails
designing and creating a database. We
were given individual space on the schools database server and we were given
SSH secure shell to connect and manage our respective databases. I took it upon myself to try out SQL Server
Express. Using the management studio I
am trying to connect to my school database and can€™t seem to figure it
out. Can someone please give a noob some
simple and quick instructions on how to achieve this?
Thank you,
Your Friendly Neighborhood Programmer,
This is the SSH product in case any one was interested, ftp://ftp.ssh.com/pub/ssh/SSHSecureShellClient-3.2.9.exe
View 1 Replies
View Related
Aug 6, 2005
Hi! I installed SQL Server on my server today and im new to it. I configured it and now im trying to make a SQL Server Project with my other computer... Then the program asks for some account information to logon to a database on the server. Then i fill it out and i get this error: Login failed for user "anaxyd". The user is not associated with a trusted SQL Server connection.
View 7 Replies
View Related
Jun 5, 2007
Hi
I have a SQLite database. I want to convert it to a SQL Server 2005 database. Can u guide me how to do it?
Imalka
View 1 Replies
View Related
May 25, 2007
Hai Everbody,
for me in my project i want to read data from a csv file and insert it in a sql server databse table.The csv file may contain n number of columns,but i want only certain columns from that, and insert it in the database table.How to achieve this. Plz help me it is urgent. Thanks in advance.
Thanks and regards
Biju.S.G
View 1 Replies
View Related
Mar 11, 1999
Hi,
I have to export the table data from my databse into text files as I nedd to put it in Informix database using a sheel script. Is there a way by which I can do this.
Is there any other way by which I can put the data from SQL Server to Informix.
Any takers,
Thanking you in advance.
Bye for now,
Himauhu
View 1 Replies
View Related
Oct 26, 2000
hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed
I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.
I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.
My next question, How to configure MAPI in Sql server if what I did was wrong.
View 1 Replies
View Related
Mar 23, 2001
Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.
Please help me to start sql server.
Thanks.
Michel
View 4 Replies
View Related
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
Aug 31, 2006
i'm making a web page for a clinic.it needs to be able to search for patients by first name, surname, date of birth and patient number.i'm using visual web developer and i have my database, my data source and GridView grid.i want 4 text boxes for my first name, surname etc. when u click enter on any of them i want to retrieve all their data and display it in the gridview.at the moment i have one text box on the web page and through the "Configure data source" option on the grid view i can retrieve the specified data but for only this one item, e.g. SELECT * FROM [Patients] WHERE ([DOB] = @DOB). if i add another text box to my web page, and don't do anything to it, the query wont run. if i add and "AND" statement to the query, e.g. SELECT * FROM [Patients] WHERE (([DOB] = @DOB) AND ([FirstName] = @FirstName)), again it won'r run or return and data. any ideas on what i can do or where i'm going wrong. thanks
View 1 Replies
View Related
May 18, 2000
Does anyone know how I can receive some type of notification (an alert) that fires when a new database is created (or an old one deleted) on a server?
Thanks.
View 1 Replies
View Related
Sep 10, 2007
Dear All I've made transactional replication between two SQL 2005 servers.Everything looks fine, synchronization working fine, no errors, however size of replicated database file = 97 Mb,on Publications server the database file size = 184 Mb. What is wrong :S ? Best RegardsPiotr
View 5 Replies
View Related
Apr 6, 2008
Hi,
I had downloded MS SQL express from Microsoft. But i did not find any place from where i can create databse, table etc..
please help me regarding this.
thanks
Sabbir
View 3 Replies
View Related
Jun 29, 2006
hi, im totally new to this sql thing.
i have a set of classes here and my objective is to show that they can connect to the database. how am i supposed to do this?
can i post my classes here? theres a lot..
View 8 Replies
View Related
Apr 7, 2007
Hi, my database i am working on is full of crab, who do I clear all the tables info?
View 3 Replies
View Related
Aug 2, 2007
How to create a database in MS SQLserver 2005 express edition.
Pleae help me to get started.I have learned some SQL commands.
But i want to execute those in SQLserver 2005.But i don't know the procedure for creating a database.please help me on this.
View 5 Replies
View Related
Sep 21, 2007
Im creating a sample database for purposes of keeping track of employee's jobs + billing codes for that job. currently they just use an excel spreadsheet to keep track of billing.
Question 1:
What would be the easiest way for the manager to enter billing codes? Billing codes are numbers like 956, 958, 805 and they co-relate to prices for each billing code.
1. I want the manager to enter the billing code and have the sql database find out how much that code is and add them up daily. This would prevent the manager from having to input prices and billing codes, and extra step.
Any links on the above topic would be helpful. I'm not looking for anyone to spoon feed me code just point me in the right direction. Im relatively new to sql having only a class of sql @ ITT.
Heres the way I have the db tables laid out currently.
employee table
employee_id
technumber
fname
lname
address
workphone
homephone
trucknumber
officelocation
employeejobs table
employee_id
jobs_id
jobs table
jobs_id
codes
date
timeframe
city
hours table
hours_id
employee_id
hoursworked
month
Any info would be much appreciated, Im going to go find a sql book now ;).
View 1 Replies
View Related
Jul 20, 2005
hi everyoneCould someone please help me in following:One of my database in SQL 2000 going Offline automatically. When ibring it back Online its Ok for 20/30 minutes and then again appear asOffline. I had similar problem when one of the database keep going to'Single user' automatically.Any idea what happening.Thank you*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Jul 20, 2005
Hi, there is an existing application running on a SQL Server database.Now I have to built a different app, which will have two common tableswith the existing database (Customers, sales)Is there any benefit (performance mainly) creating the tables for thenew app in a new database? (On the same machine and the same instance)*** Sent via Devdex http://www.devdex.com ***Don't just participate in USENET...get rewarded for it!
View 3 Replies
View Related
Jun 21, 2007
I went and detached a database. It is no longer showing in EM. I try to attach the database and I do not have any MDF files anywhere on my PC. Where did my database go when I detached it? How can I get it back. Please help.
Thank you
View 6 Replies
View Related
May 7, 2007
Hi,
I am doing one E-commerce Application , throgh C#. & sql server express editon. Both my Local & Web Hosting servers are in sql server express 2005. I designed Databse Throghly, to my local server. Now I want to Transfer tables to my web server. I have already Sql server mangement studio Express. I can not do.. I spent, more than 5 yrs time..
Please help asasp..
Thanks
Partha
View 1 Replies
View Related
Oct 4, 2006
I have a system running on SQL Sever and i am trying to create a second file on a diffrent computer so that I can teach people how to use sql sever (express) without risking losing any data that I have on my proper database.
I have created a backup of my database which is in a dmp file and I would like to import this into SQL Server Management Studio Express so that I can make changes to the databse without affecting the one that is running on my website.
Cheers for any help
View 10 Replies
View Related
Nov 6, 2006
I would like to run some queries on two tables that reside in two different database (located on the same server). The databases are both MS SQL 2000.How do I create a database link (or a table link??) so that I can create the queries from the Enterprise Manager or the Query Analyzer? Thanks a lot, Christian
View 1 Replies
View Related
Dec 1, 2006
I am using the SQLEXPRESS database, and connect from to locations:
Windows Service
ASP.NET web application.
whenever I start the windows service I get the error: Cannot open user default database. Login failed.
so I am going to visual studio and close the connection. then I close the web browser, and the windows service succeed connect to database.
but then, after windows service is connected, I open the web browser application and fails to login because the login system using the same database of windows service, and since the connection is being used by windows service, login is impossible.
Do you know how I can allow 2 connections at the same time for the same database?
what are the risks to do that? and how do I handle this risks.
thanks alot
View 3 Replies
View Related
Mar 2, 2007
Hi,
I have a SQL Server 2005 Express database dbase.mdf which I cannot access. It works fine in VWD and the development server using the following connection string: String connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbase.mdf;Integrated Security=True;User Instance=True"But when the site is not on the development server but on IIS, I get a SqlException saying "User does not have permission to perform this action." when I execute the connection.Open() command. I find it extremely frustrating that something which works in the development server fails on the real server. Can anyone help me with this? Do I have to change my connection string, or perhaps set some permissions...I have already given the IUSR_MACHINENAME account and the ASPNET account full access to dbase.mdf. Surely this must be an issue that lots of people deal with... How do other people manage to log to access databases? Any help would be much appreciated. Thanks,P1000
View 4 Replies
View Related
Dec 27, 2007
can any body tell me how to update the database thru dataadpater ???????
and another imp thing.........
if there r 2000 rows in database ..........and updation of 2 rows takes place
i want that whole of the database should not be updated ......only those two rows are updated
Can any one help me please??????
thanks in advance
View 1 Replies
View Related
