Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jheds
Starting Member
17 Posts |
 Posted - 2006-12-26 : 07:42:59
|
Hi Friends,CASE 1) I create a Database TRY. the .MDF and .LDF files are created. Now Is there any way in which if I delete the Database TRY but the .LDF file does not get deleted?There is a scenario where the database doesnt exist but its .LDF is present . HOW can this happenCASE 2) if there is a .LDF for a databse and I want to copy it to another location it gives me an error that the file is in use by another application. HOW can i copy it to another locationKindly help guys its urgent. Regards,Jheds |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-26 : 07:51:17
|
quote:
There is a scenario where the database doesnt exist but its .LDF is present . HOW can this happen
This happens when you make a copy of LDF. quote:
HOW can i copy it to another location
You need to detach the database and then copy the .LDF file.But question is why you need to do this?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-26 : 13:18:27
|
| "if there is a .LDF for a databse and I want to copy it to another location"There is no point copying the LDF file on its own, without its corresponding MDF file.Also, people who ask this type of question are usually solving some database-transfer problem "the wrong way". What's the problem you are trying to solve? If you want to move / copy a database from one server to another take a backup and restore it on the target server (and then you need to sort out the logins)Kristen |
|
|
|
Jheds
Starting Member
17 Posts |
Posted - 2006-12-27 : 08:58:28
|
| Thanks harsh & kirsten, for your time and replies. it sure helped me to clarify some extremely doubts. i was able to accomplish what i wanted to. thanks again. But you see the TEMPDB cant be detached .how can we do this?please help.Jheds |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-27 : 15:22:07
|
| "But you see the TEMPDB cant be detached .how can we do this?"It would have been a great help if you had explained that what you wanted to do was to transfer TEMPDB to another location ..... as per the question you asked a day later:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76851The problem you are facing is the all important point ... NOT your proposed solution to your problem!Kristen |
|
|
|
|
|
|
Please Help its Urgent !! LOG Files .LDF