|
i forgot to say i am using sql server 2000
|
|
|
|
|
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
|
|
|
|
|
thank you
i will try the same
chandru
|
|
|
|
|
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
|
|
|
|
|
your query is not clear. can pls explain
Regards
KP
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
hi KP
thank you very much
it works
regads
chandru
|
|
|
|
|
Hi KP
Thank you very much
it worked
regards
chandru
|
|
|
|
|
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
|
|
|
|
|
hi all,
How to use Rollback in sql server. can anyone help me in it.
Tech_spidy
|
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
You can check this article[^]
you can execute it's code in query analyzer too.
|
|
|
|
|
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
|
|
|
|
|
shld get executed!!!
by the way what is the error in your main sp??
Gautham
|
|
|
|
|
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
|
|
|
|
|
SELECT * FROM [Sheet1$A1:A1000]
|
|
|
|
|
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
|
|
|
|
|
use adapter to fill data .and use them like
myDataTable.Rows[row_num][column_no]
|
|
|
|
|
thanx so much .. let me try it out !!
|
|
|
|