restore database - Microsoft SQL Server

deepji2007

hi,
i am facing one problem when i am going to restore backup file. there is one maasage is come (restore detabase must be used in single user mode when trying to restore the master database. restore database is terminating abnormally)

Aug 1 '07 #1

Subscribe Post Reply

2135

bwestover

hi,
i am facing one problem when i am going to restore backup file. there is one maasage is come (restore detabase must be used in single user mode when trying to restore the master database. restore database is terminating abnormally)

The master database contains information about every other DB in the system.

Therefore in order to overwrite it, it has to be in a special mode where only one string of information could possibly be coming in.

To start SQL Server in single user mode, stop the SQL server and start it again using this command.

sqlservr -m

If this doesnt work, try browsing to the \Microsoft SQL Server\80\Tools\binn directory.

**note overwriting your master database can be very dangerous. Only do this if its completely necessary.

Aug 1 '07 #2

deepji2007

hi,
i have stoped the SQL server but from where i give the commabd (sqlservr-m)

Aug 2 '07 #3

bwestover

hi,
i have stoped the SQL server but from where i give the commabd (sqlservr-m)

From a command prompt type:

C:\> CD program files\microsoft sql server\80\tools\binn

C:\> sqlservr -m

Aug 2 '07 #4

Similar topics

Backup / Restore Question - MSDE

by: Tim Morrison | last post by:

MSDE2000 I have an application in which I am running a TSQL command of BACKUP DATABASE and RESTORE DATABASE for the backup and restore commands for my application. For testing purposes, i did the...

Microsoft SQL Server

I can't restore the transaction I needed! Help!

by: xo55ox | last post by:

Hi, I have been trying to set up an automated restore process from prod to backup server. First, I schedule the full database backup nightly, transfer the backup file and restore it to the...

Microsoft SQL Server

Database Restore Woes

by: Jon Jacobs | last post by:

I attempt to back up a database on one server and restore it on my local machine. This is what the query text looks like: restore database model from Disk='c:\JQJ\mydump\model.bak' with...

Microsoft SQL Server

backup/restore nTs data

by: Hardy | last post by:

hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but...

DB2 Database

Problem with redirected restore

by: GL | last post by:

I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following “SQL2059W A device full warning was...

DB2 Database

can I restore a database from one system to another?

by: anna_cheng11 | last post by:

We do not have a DBA available, and this is a development environment, hence I was asked to do the work. I am not a DBA. I need some help to clarify my understanding of DB2 recovery and I am...

DB2 Database

Redirected restore problem

by: Chris | last post by:

I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...

DB2 Database

How to Restore an Archived Filegroup on Another Server

by: Takpol | last post by:

Hello, I have several archived filegroups that have data in them partitioned based on the date. These filegroups have been removed from database after archival. For example two months ago....

Microsoft SQL Server

need to restore old database (database server 4.01 AIX)

by: HSP | last post by:

hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup...

DB2 Database

Restore database from v7.2 to v8.2

by: chow.justy | last post by:

Dear all, I'm a new beginner of DB2. I face 2 question during restore the data. I have 2 DB2 servers on my company. Server A is running on V7.2 and Server B is running on v8.2 (Enterprise...

DB2 Database

How to Become a Cyber Security Engineer

by: Rina0 | last post by:

Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...

Security

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

Speedup your spring application

by: linyimin | last post by:

Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...

General

Development of Funny H5 Game - Toy Claw

by: kcodez | last post by:

As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...

HTML / CSS

How to insert a new record in a database

by: Taofi | last post by:

I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...

DB2 Database

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA