Computers & Internet Logo

Related Topics:

Rajavel Posted on Sep 10, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Need Help to backup SQL database in safe mode

Hi, I am in need of backup SQL database.I am using SQL 2005. As my system have some driver problem i cant able to get into system by normal mode. but i can able to get into by safe mode. As safe mode does not allow remote connections i cant able to login to the Sql database. Pls Help to backup the database.
Thank you

5 Answers

Michael Lang

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Problem Solver:

An expert who has answered 5 questions.

  • Contributor 8 Answers
  • Posted on Nov 19, 2014
Michael Lang
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Problem Solver:

An expert who has answered 5 questions.

Joined: Nov 19, 2014
Answers
8
Questions
0
Helped
3754
Points
8

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/

Herb Ritts

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Hot-Shot:

An expert who has answered 20 questions.

  • Contributor 33 Answers
  • Posted on Jul 15, 2014
Herb Ritts
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Hot-Shot:

An expert who has answered 20 questions.

Joined: Mar 31, 2014
Answers
33
Questions
3
Helped
9725
Points
49

If you search about such tool on Internet, so I suggest you easy way to find good tool for .mdf file corruption. Try RecoveryFix for SQL database recovery software to recover and repair your .mdf file from damaged SQL server database. To know more see this site: http://www.mdf.repairsqlserver.net and also read this post http://diskdatarecovery.jimdo.com/2013/07/23/how-to-restore-lost-data-on-server-while-running-sql-server

Ad

George Billy

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Corporal:

An expert that has over 10 points.

  • Contributor 11 Answers
  • Posted on Jun 12, 2014
George Billy
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Corporal:

An expert that has over 10 points.

Joined: Jun 06, 2014
Answers
11
Questions
0
Helped
6002
Points
12

I found new application on Internet called MS SQL server database recovery application. This application can help you recover mdf files. More details you can visit this site http://www.en.repairsqlserver.net and also read this post http://recoverymaster.livejournal.com

Alexey Krenvalk

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Sergeant:

An expert that has over 500 points.

Champion:

An expert who has answered 200 questions.

  • Microsoft Expert 419 Answers
  • Posted on Jun 26, 2012
Alexey Krenvalk
Microsoft Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Sergeant:

An expert that has over 500 points.

Champion:

An expert who has answered 200 questions.

Joined: Sep 18, 2007
Answers
419
Questions
0
Helped
309171
Points
517

To backup and recover sql data you need to use following source SQL Server Repair Toolbox software very likely will help you

mukhtar21 shaikh

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

President:

An expert whose answer got voted for 500 times.

  • Master 2,022 Answers
  • Posted on Sep 10, 2009
mukhtar21 shaikh
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

President:

An expert whose answer got voted for 500 times.

Joined: Sep 21, 2007
Answers
2022
Questions
1
Helped
669294
Points
5817

Kindly choose the option safe mode with networking and then try.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1helpful
2answers

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/
tip

Tricks for Keeping SQL Server Safely

Some simple ways to protect your SQL Server database

1. Using the Microsoft Baseline Security Analyzer (MBSA) to assess the server's security
MBSA is one of a variety of Microsoft products, which can scan unsafe configuration tools. It can be run locally; you can also run through the network.

2. Isolate your server and regularly back up
Physical and logical isolation would form the basis of SQL Server security. Database should be installed within the enterprise network security area, but not directly connected to the Internet. Back up all data regularly and store copies in a safe location outside the site.

3. Assign a strong SA password for a SA account
SA account should always have a strong password, even if Windows is configured to require authentication of the server. This will ensure that the server has been reconfigured in the future as Mixed Mode authentication; it will not appear blank or weak SA.

4. Restrict the permissions SQL Server service
SQL Server 2000 and SQL Server Agent is running as a Windows service. Each service must be associated with a Windows account, and derive from this account security context. SA log in SQL Server allows the user (sometimes including other users) to access the operating system features.

About reset SA password in SQL 2008/2005/2000

To secure our database we would like to choose create an intricate password. But even our selves would forget the SA password in SQL Server 2005/2008 sometimes. So here is a way for you to reset SQL Server 2005 password -- MS SQL Server Password Unlocker, which is a highly A Highly Technical and Safe SQL password 2005 Recovery tool. And following is a few features of the tool.

Features:

* Support SQL Server password recovery for MS SQL Server and MS SQL Server Express 2008/2005/2000

* No need to install MS SQL Server on your PC or lose data, the file master.mdf format is necessary

* Stop and resume MS SQL service automatically if the MS SQL Server on your PC is running

* Reset SQL password with ease no matter how long and complicated the SQL password is

* Easy to use

Feedback:

The most of people who encountered with SQL 2005 password losing problems are getting back to their SQL account now. We can also feel that ease and the hilarious mood when a hard nut has been cracked. Hope this MS SQL Server Password Unlocker would help more people and get their trouble erased.
on Nov 12, 2010 • Computers & Internet
0helpful
4answers

Is it good idea to repair sql file?

Bulk Logged will not help you in this situation. Your transaction log is growing because you are performing large transactions. In simple mode, the log is truncated after a checkpoint.
Check these site: http://www.sql.recoverytoolbox.com/ & download demo Recovery Toolbox for SQL Server.
Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.
Read more: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/380-is-it-good-idea-to-change-simple-recover-model-into-bulk-logged-on-etl-system
4helpful
6answers

How to recover deleted Microsoft SQL server MDF files?

Recover and repair MDF files with simple and efficetive tool to repair and recover MDF files from corrupt and damaged SQL server, which tool support all king of SQL server version and Windows OS. Visit here: http://www.en.mdfrepair.net
Read blog post: http://exchangerecovery.hubpages.com/hub/How-to-perform-SQL-Database-Recovery Corrupt MDF File Repair Utility
0helpful
2answers

How to convert SQl server 2005 to SQL server 2008

upgrade it or
take backup of your database
install sql server 2008
Restore backup in sql server 2008
0helpful
4answers

Hay Bahratt, I have uninstalled the 3 SQL programs in the control panel a few times with no effect on the issue. I didn't try moving directory C:\Program Files\Microsoft SQL Server\MSSQL to another...

If you have removed it from control panel, its done. You just have to clean up any left over registry entries using CCleaner and then try installing again
http://www.ccleaner.com/download
You may also want to check out this microsoft link if it doesn;t work
http://office.microsoft.com/en-us/help/HP011128601033.aspx
0helpful
5answers

How get sql data backup

there is facility in enterprise manager to take back of database!
0helpful
3answers

Hi...........

Well there is more than one or two answers 4 that.
you should first check if you are at simple recovery mode. If not (now this will sound strange) right click the database, click tasks/backup and make a LOG backup.
Now right click databases and click Restore Database.
You should choose a new database name (for restore practice) .
You will probably have your last backups at the bottom of the screen...if not click add and choose you latest data backup.
click the log backup and the data backup should be checked , too. on options tab make sure the database is left ready to use.
Not finding what you are looking for?

405 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...