Database

FirstPrevNext

copy sql data base to some other machine chandru701-Mar-07 20:38 chandru70 1-Mar-07 20:38  I have database present in one m/c sql server and i have taken backup of the database. I want to restore the backup file into another m/c which has sql server how to go about Pls help me.. regards chandru Re: copy sql data base to some other machine chandru701-Mar-07 20:42 chandru70 1-Mar-07 20:42  i forgot to say i am using sql server 2000 Re: copy sql data base to some other machine Krish - KP1-Mar-07 22:42 Krish - KP 1-Mar-07 22:42  take database offline from the frist machine. copy MDF & LDF files to other machine and attach them (right click on database node select AllTasks->Attach from SQL enterprise manager) OR create a new database with same name in another m/c and restore the backup taken from the first m/c Regards KP Re: copy sql data base to some other machine chandru701-Mar-07 23:12 chandru70 1-Mar-07 23:12  thank you i will try the same chandru Re: copy sql data base to some other machine chandru703-Mar-07 20:30 chandru70 3-Mar-07 20:30  hi i have taken backup from orginal pc, and created new database in another m/c but if i try to take backup from the backup file it will not shown in that form. How to go about please guide me about this. regards chandru Re: copy sql data base to some other machine Krish - KP4-Mar-07 21:44 Krish - KP 4-Mar-07 21:44  your query is not clear. can pls explain Regards KP Re: copy sql data base to some other machine chandru704-Mar-07 23:56 chandru70 4-Mar-07 23:56  hi kirsh thank you for your reply my problem is in the second m/c when i try to restore the database, it lists only backups that are taken on that second m/c. i was unable to get backuped file which is copied from the first m/c for restore command hope you under stood sorry for inconvenience regards chandru Re: copy sql data base to some other machine Krish - KP5-Mar-07 2:49 Krish - KP 5-Mar-07 2:49  from SQL Enterprise Manager select the database right click 1. select "All tasks" 2. select "restore database" 3. From the "General" tab ... 4. select "FromDevice" option 5. click on "SelectDevices..." to borwse and select the backup 6. go to "Options tab" 7. if the path under "Moive to Physical file name" is pointing to another folder than the actual folder change the same (other wise thros err stating "Move ... Physical file ...." some thing like this" 8. also you can select "Force restore over existing database" Regards KP Re: copy sql data base to some other machine chandru705-Mar-07 16:35 chandru70 5-Mar-07 16:35  hi KP thank you very much it works regads chandru Re: copy sql data base to some other machine chandru705-Mar-07 16:43 chandru70 5-Mar-07 16:43  Hi KP Thank you very much it worked regards chandru Re: copy sql data base to some other machine alexrad2-Mar-07 22:20 alexrad 2-Mar-07 22:20  From Enterprise Manager do backUp Database and restore but with another name and in option tab do the right location. Take ofline and Bring on line is not such great idea. backup and restore is option for such task SQL : Rollback Tech_spidy1-Mar-07 19:22 Tech_spidy 1-Mar-07 19:22  hi all, How to use Rollback in sql server. can anyone help me in it. Tech_spidy Re: SQL : Rollback Hesham Amin1-Mar-07 20:54 Hesham Amin 1-Mar-07 20:54  Check this article[^] Hesham A. Amin blog connection string of an Aceess data base with DSN ??? sabindas k s1-Mar-07 19:18 sabindas k s 1-Mar-07 19:18  how can i write a connection string in c# .net to work with a dsn in a remote/local system for msAccess db. Waiting eagerly sabindas@gmail.com Re: connection string of an Aceess data base with DSN ??? Hesham Amin1-Mar-07 20:53 Hesham Amin 1-Mar-07 20:53  Configure the connection from : Administrative Tools->Data Sources(ODBC) and make the connection string like in this link: http://www.connectionstrings.com/?carrier=dsn[^] What do you mean by remote system ? do you want to access Access database on a server from clients? Or to place it on a shared folder? Hesham A. Amin blog dsn of a Aceess data base sabindas k s1-Mar-07 19:17 sabindas k s 1-Mar-07 19:17  how can i write a connection string in c# .net to work with a dsn in a remote/local system for msAccess db. Waiting eagerly sabindas@gmail.com Re: dsn of a Aceess data base Krish - KP1-Mar-07 22:30 Krish - KP 1-Mar-07 22:30  connStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=bran.mdb;Jet OLEDB:Database Password=n123"; System.Data.OleDb.OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = connStr; Regards KP Transaction in Sql Server 2000 Vinay Dornala1-Mar-07 19:07 Vinay Dornala 1-Mar-07 19:07  Hi All, I am now to sql server 2000 ,pls clarify my doubt, I have transaction within another if it fails to execute the entire transcation also rollback or not, if the problem in main transaction then what's happend pls give some information about transcation concept, Thanks N Advance Re: Transaction in Sql Server 2000 Hesham Amin1-Mar-07 20:49 Hesham Amin 1-Mar-07 20:49  You can check this article[^] you can execute it's code in query analyzer too. Hesham A. Amin blog Pls give clarification about transaction in sql server 2000 Vinay Dornala1-Mar-07 18:52 Vinay Dornala 1-Mar-07 18:52  Hi All IAm just started learning sql server 2000. I have on stored procedure sp_getdepdetails I Am writng another stored procedure sp_getempdetails in that calling with exec sp_getdepdetails. but error in sp_getdepdetails. my doubt is sp_getemodetails is executed or not Thanks N advance Re: Pls give clarification about transaction in sql server 2000 gauthee1-Mar-07 20:07 gauthee 1-Mar-07 20:07  shld get executed!!! by the way what is the error in your main sp?? Gautham Query to access excel data.... AnnnS1-Mar-07 18:45 AnnnS 1-Mar-07 18:45  hi all i am using odbc connection to query the data from excel ... i am able to ... the query i use is select empid from [sheet1$]... (empid is the column header in the first row) the problem is i want to access the data by ponting the index of the column .. something like select column1 from [sheet1$] can anyone suggest the query for that ??? Annns Re: Query to access excel data.... sam#1-Mar-07 19:00 sam# 1-Mar-07 19:00  SELECT * FROM [Sheet1$A1:A1000] Re: Query to access excel data.... AnnnS1-Mar-07 19:12 AnnnS 1-Mar-07 19:12  thanx for the reply .. hope it will help me... but still one more doubt ... then how will we get the value from result set?? like rs.getString("?"); ??? Thnks Annns Re: Query to access excel data.... sam#1-Mar-07 20:57 sam# 1-Mar-07 20:57  use adapter to fill data .and use them like myDataTable.Rows[row_num][column_no]

Last Visit: 31-Dec-99 18:00     Last Update: 2-May-24 4:42 Refresh ᐊ Prev1...1648164916501651165216531654165516561657 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.