Question about Microsoft Business & Productivity Software

1 Answer

Sql server good morning sir, i am working as data base administrator. recently i was joined. i want know about DBA. what my work would be. and what i want to learn to get real expert in DBA.please give suggetion to me. thank you sir ranjit routhu from hyderabad, india

Posted by on

  • ranjitrou Oct 27, 2008

    thank you sir. but i am working in sqlserver2000.now i am writing stored procedures and .giving reports.so i want to know about sql2000.plz reply me sir

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 35 Answers

A good point to begin is to start preparing for the Microsoft Certified IT Professional Developer (MCITP) Certifications for Microsoft SQL Server 2008. For more information about this certification please visit:
http://www.microsoft.com/learning/mcp/mcitp/sql/2008/default.mspx

As an Administrator you should start with this certification:
MCTS: SQL Server 2008, Implementation and Maintenance

I recommend buying the self-paced training books recommended for this exam which can be found here:
http://www.microsoft.com/learning/en/us/exams/70-432.mspx

Even if you do not want to apply for the exam. These resources are the perfect place to start.

Good luck

Posted on Oct 27, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

Repair a corrupt SQL database in SQL 2005


Known as the leading solution provider in the field of data recovery and data conversions, the company has created a niche for another efficient tool known as SQL Server Repair Toolbox. The MS SQL repair tool reads *.mdf and *.ndf files and saves data, structure, links, etc. as SQL scripts or exports directly to Microsoft SQL Server through direct connect. read more details SQL Server Repair Toolbox

Jun 13, 2015 | Microsoft SQL Server 2005 Enterprise...

2 Answers

Creating a new database using an MDF file


An MDF file isn't a backup file isn't the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks and then Attach Database.
When you do this you will get an error about the log file missing. This shouldn't matter as SQL Server will simply create a new log file for you.
This will only work if the SQL Server was stopped when you copied the MDF file from the old SQL Server. If you copied the file while the SQL Server was running this file probably will not attach either and you will need to get a valid backup of the database.
Download help tool for sql database - SQL Server Restore Toolbox.
http://www.sqlserver.restoretools.com/
You can read up more on SQL Server here.
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/498-creating-a-new-database-using-an-mdf-file?_=1416149856104/

Nov 16, 2014 | Microsoft SQL Server 2000 Standard Edition...

5 Answers

What the presager of SQL repair by any tool


Latest tool is here if you want try please use SQL repair tool to repair and recover MDF file with loss of any data. Visit here:-

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

2 Answers

Sql procedure


Dear friend you can get all your answers about stored procedure in sql server through this link:
http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx

good luck

Feb 25, 2009 | Microsoft SQL Server 2005 Enterprise...

4 Answers

How get sql data backup


there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

1 Answer

SQL server won't work on my laptop


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.

Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

202 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...