473,569 Members | 2,573 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to attach a MS SQL 2005 database (.mdf) file to MS SQL 2000

1 New Member
I have 2 files from MS SQL 2005, .mdf and .ldf . How am I going to attach it to the MS SQL 2000? Does it need converter? Please guide.
Thanks.
May 18 '07 #1
2 6209
Natish
2 New Member
I have 2 files from MS SQL 2005, .mdf and .ldf . How am I going to attach it to the MS SQL 2000? Does it need converter? Please guide.
Thanks.

with enterprise tools u can attach the datbase
May 19 '07 #2
MMcCarthy
14,534 Recognized Expert Moderator MVP
You have posted this question in the Articles section. I am moving it to the SQL Server forum.

ADMIN
May 19 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3495
by: Moti | last post by:
I have SQL server 2000 which recently crashed. I try to recover it and found out that the Master database is corrupt. I never backup my server using inline sql backup nor any third party backup program that aware to SQL server. But I have full system backup of volume c on tape (using NTBackup), which includes old version of Master database. My...
3
22878
by: Tim | last post by:
Hello, We do not run SQL Server in our shop, but I'm starting to be tasked with analyzing SQL Server databases from outside shops. I will need to open .MDF files sent to me. Can I do this using SQL Server 2005 Developer version? Or do we have to spring for the Workgroup version? Thanks, in advance, for your help. T
3
8613
by: Freddie | last post by:
hi, i try to get the asp.net 2.0 security controls to work with SQL Server 2005 Dev RTM, this is my connetion string in mashine.config <connectionStrings> <add name="LocalSqlServer" connectionString="data source=.;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=false;"...
2
2046
by: prajeeshv | last post by:
Hi Everyone, Have a nice day... I've a problem in SQL Server... I've detached my database from server. But I didn't remember the location of its .mdf (database) file. Now I'm unable to attach the database. Is there any way to locate the mdf file for a detached database, so I can attach it again... Any help on this will be...
3
24227
by: weird0 | last post by:
This is the exception that I get when i create a webserivce obj and call. The error comes on the webmethod call, when it opens a connection to the db. How do I fix it? What is the solution to this? System.Web.Services.Protocols.SoapException: Server was unable to process request. ---System.Data.SqlClient.SqlException: An attempt to...
12
10953
by: Darrel | last post by:
I'm still having a hell of a time figuring out this whole SQL Express set up. I finally discovered why I couldn't run the aspnet_regsql...my local sql server wasn't running. I turned that on, and now I can see a list of DBs running locally. However, the .mdf file I have in my app_data folder does NOT appear on this list.
16
2422
Dököll
by: Dököll | last post by:
Hey Gang! I just ran through a wonderful Microsoft video for VS 2005 Web Dev and SQL 2005 Express. Data added to SQL .mdf file through VS web site... How does one query the data in the SQL .mdf file? I can browse the database data through VS Web Dev application, and the database name is clearly visible when I locate the folders, but...
1
2086
by: Gilles Nambert | last post by:
Hi, I'm not familiar with backup procedures of SQL Server (i'm used to make simple file copies when no body works) and i have now the following message : Invalid header for the Base.mdf file. The property FILE SIZE is incorrect. Of course, i have some data to recover since the last good file. So, I
1
1715
by: RomeoX | last post by:
hi everyone here, hope u r doing well My question that I want to make a page in ASP.Net based on database and I'm a newbie, recently I have got a complete project that one of my friend gave it to me, made in ASP.Net plus SQL Server. I want to add pages and some code in that and I want to start it in my local server in Win 7 ultimate for a...
0
7615
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7979
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5514
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5219
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3653
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3643
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2115
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1223
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
940
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.