Restore puts copy of user tables in master

Emille378

Environment is SQL Server 2000 64 bit.
I restore from a script 'my' database, this works fine. However, all
the tables are also found in master, no data though.
Anyone experienced this?

Jul 20 '05 #1

Subscribe Post Reply

2021

Greg D. Moore \(Strider\)

"Emille378" <di******@seidata.com> wrote in message
news:d2*************************@posting.google.co m...

Environment is SQL Server 2000 64 bit.
I restore from a script 'my' database, this works fine. However, all
the tables are also found in master, no data though.
Anyone experienced this?

Can you show us the script?

Jul 20 '05 #2

Emille378

"Greg D. Moore \(Strider\)" <mo****************@greenms.com> wrote in message news:<%f********************@twister.nyroc.rr.com> ...

"Emille378" <di******@seidata.com> wrote in message
news:d2*************************@posting.google.co m...
Environment is SQL Server 2000 64 bit.
I restore from a script 'my' database, this works fine. However, all
the tables are also found in master, no data though.
Anyone experienced this?

Can you show us the script?

RESTORE DATABASE XX
FROM DISK = 'g:\XX_db.BAK'
WITH STATS = 10, REPLACE,
MOVE 'XX_data' TO 'h:\Program Files\Microsoft SQL
Server\MSSQL\Data\XX_Data.mdf',
MOVE 'XX_log' TO 'g:\logs\XX_Log.ldf',
MOVE 'XX_Indx' TO 'h:\Program Files\Microsoft SQL
Server\MSSQL\Data\XX_Indx_Data.NDF'

Jul 20 '05 #3

Similar topics

Restore database via automated order

by: FoxRunner | last post by:

Hi folks, I got a script which restores a database. It works fine if it is running in my Query Analyzer. It fails when I put this script in an automated schedule using the SQL agent. This...

Microsoft SQL Server

Can I carry my existing DB users to a new server and restore???

by: SD | last post by:

Hi, Quick question, I have about 20 users in my local server and database. We are looking to restore that database to a new server in a new network and still be able to retain the database...

Microsoft SQL Server

Restore puts copy of user tables in master

by: Emille378 | last post by:

Environment is SQL Server 2000 64 bit. I restore from a script 'my' database, this works fine. However, all the tables are also found in master, no data though. Anyone experienced this?

Microsoft SQL Server

mysqldump and restore of Innodb Tables

by: Rajesh Kapur | last post by:

Hello, We are on MySQL 4.0.21 on linux. We use InnoDB tables and foreign key constraints extensively. The mysqldump backs up the database tables in alphabetical order with foreign key...

MySQL Database

master db restore

by: Dishan Fernando | last post by:

Hi., Can restore master database and other databases from one server to other. I cant restore master database. i stared server in single user mode, and restore master database. it says...

Microsoft SQL Server

Restore SQL master database from a file

by: Moti.Ba | last post by:

Hello, I need to restore the Master DB in my SQL 2k server (with sp3). The problem is that i don't have SQL backups of this file I only have general backup of the entire c:\ drive i made using...

Microsoft SQL Server

Restore Messed Up Table Names

by: David C. Barber | last post by:

Using SQL Server 2000 and moving to a new computer. We did a full backup of the existing database to tape, brought up the new computer with a clean install using the same server name and IP...

Microsoft SQL Server

Using Steven Lebans "A97Save-Restore-Modify-RelationshipWindowLayout" A97

by: lesperancer | last post by:

it looks like this will save many versions of a relationship window, but based on the fact that the same tables are displayed in the relationship window and it will restore versions of what was...

Microsoft Access / VBA

Incremental table backup or restore

by: rdemyan via AccessMonster.com | last post by:

For some of my really important tables, I have backup tables in the backend file. The idea is that if a user accidentally screws up data, they can go to a form and restore from the backup table...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server