- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
I would like to suggest you to use of MDF Repair Kit. An exciting new product from Repair Kit, this MS SQL MDF repair tool is an absolutely indispensable tool for anyone who wants to know how to repair MDF files in minutes. The program is based on a powerful analysis core and uses a convenient wizard-driven UI.
LDF - layered data file, is the transaction log file for your database. It allows you to roll back changes you made to the data to a particular point and is used in rebuilding the data should it become corrupted.
MDF - Meta data file, is your actual data
SDF - Is a sequential data file, a flat file that can be used for compatibility with MS-SQL server, MySQL, etc.
There are ways to do this but assuming you are dealing with a competent hosting service you need not worry. They take care of protecting you from spiders (things that steal data) and hackers, etc. Also you host provider should offer technical support for that type of question.
If you have a bootleg copy of the software, there is nothing that can be done for you. You must not have the program installed on other computers. You must purchase an original Microsoft CD. No temporary product key is required for the trial period, unless that has changed in Office 2007. Did you purchase a new computer with office 2007 installed already?
Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.
SQL Server runs on port 1433, so any firewall has to have it open.
Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.
Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.
Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.