SQL Server 2005 - Restore Backup File Error

May 18, 2007

A full database backup file was created and placed in my C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLBackup folder. In attempting to restore the file using "Restore Database", I get the following error: System.Data.SqlClient.SqlError: Directory lookup for the file "d:Microsoft SQL ServerMSSQLdataworkspace.mdf" failed with the operating system error 3 (The system could not find the file path specified.).



Any help is appreciated.

View 6 Replies


ADVERTISEMENT

Backup File Of SQL Server 2000 Is Restore In SQL Server 2005

Feb 11, 2008

Hi Dear,

May Any one guide me?
I have a backup file of database which is in SQL Server 2000. it has no Extension.I want to restore this backupfile or this database in my SQL Server 2005.
I have tried to Attach Database or attach this backup file in Sql Server2005 but it also fails .
First I have created New database name as is on the backupfile and then I have also tried to rename this file with .bak extension and then try to restore again it fails.
Plese Guide me urgently........
:eek: :eek: :eek: :eek: :eek:

View 9 Replies View Related

Error Of Database Restore To Backup File

Jun 4, 2008

hi
i have restore database use backup file in another machine of same name of database there following error

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'database name'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The backup set holds a backup of a database other than the existing 'dbname' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

View 1 Replies View Related

Restore SQL Server Database From A File Backup

Mar 19, 2001

Hello,

I have a user database which has 1 data file and 1 logfile.
I did a complete backup of the database to a file on the disk drive, using Enterprise manager. Due to some reason, I had to drop the database. The only way I could restore it was by,
1. Create the database with the same name.
2. Restore the complete backup from the file device.

While doing so,
I get the message "Backup set holds the backup of daatabase other than the existing 'userdbname' database. BAckup terminating."

Is it because the database was dropped and recreated.
If I choose the option to overwrite, it restores successfully.

Is this normal and right way to do it? Is there any thing else that I need to take care of, while backup or restore?

Any suggestions welcome.
Thanks,
MMS

View 3 Replies View Related

Restore Backup File On SQL70 Server

Jul 24, 2001

I need to restore a backup file which resites on a network share to my local Sql70 server. Is it possible to restore a database from a backup file on the network share? Thanks!

View 3 Replies View Related

Not Able To Restore SQL Server Database From A Large Backup File

Aug 12, 2006

Hi everybody,
On executing the RESTORE command of SQL Server to restore from a backup of 78.3 MB, the "Server Application Unavailable" error message comes up.The error message in the Application log is as follows:aspnet_wp.exe  (PID: 2184) was recycled because memory consumption exceeded the 152 MB (60 percent of available RAM).
However using Query Analyser of SQL Server I am able to restore the database.
What is the solution to this problem?

View 2 Replies View Related

DB Engine :: Restore Backup File To Remote Server

Jul 8, 2015

I am working on a project for an SQL job. I am:

1.) Taking a database out of an availability group,
2.) Setting the recovery to simple,
3.) Shrinking the log file,
4.) Setting the recovery mode back to full,
5.) Then backing it up.

I need to restore the file to my secondary server with replace and non recovery mode. I am having trouble performing that call?  I have the code to reestablish the database to the availability group if I can get the restore feature working. 

View 11 Replies View Related

Sql Server 2005 Backup && Restore

Dec 27, 2007

Morning guys,
What is the equivalent to the taskpad on sql server 2005?
I want to be able to see when the last backup and restore was performed via transact sql ......
how would you go about that..... ?
what would I search... ?

View 2 Replies View Related

SQL Server 2005 TR With IU/QUS - Restore From A Backup

Feb 22, 2007

Hello,

SQL Server 2005 TR with IU/QUS - Restore from a backup

Im trying to set-up the above using sp1. It all works fine until the final step, creating a subscription through sp_addarticle and Im getting the following error:

Msg 8152, Level 16, State 10, Procedure sp_MSget_synctran_commands, Line 198
String or binary data would be truncated.

This worked fine on my laptop with a small table with a couple of columns.Now Ive looked at this error and its like

select * from #art_commands

The table only has 49 columns in it, so its not huge.

What are my options for solving/getting around this problem:

1. Try and fix sp_MSget_synctran_commands, from memory, #art_commands has a nvarchar(max) column and Im wondering if this is related. must admit, havent really looked solidly at this sp yet.

2. SP2 doesnt look like it fixes this problem.

3. Create a bespoke method to replicate.

4. anymore for anymore?

It will be impossible to synchronize the databases so this restore from backup was my only option. Im a bit stuck now, can anyone help?

many thanks,

John P

View 3 Replies View Related

SQL Server 2005 For TFS Backup&&Restore

Oct 31, 2006



Hi, Our Sharepoint of TFS was down a couple of days ago. By luck, we had fully backed up SQL database. Now, the problem is, I uninstalled everything and tried to move TFS to a new server machine on the domain. I installed freshly everything and tried to restore all the databases (with tables also). Now the problems are these:

1 - Since there are lots of different backup-restore procedures telling on the Internet from some forums and this forum also: What should i do basically to make the configuration of Sharepoint and Reporting Services to make them work correctly?

2 - Secondly, even if i fail in the problem above, I, at least, want to save the source control files and sharepoint files. Where can I find them and how can I take them back to my new TFS installation?

3 - If these problems exist and Suppose on a new project on the new installation, i create new WI's, documents (with new Version Control information), and new SPS configuration. And on a new release,the problems are resolved. Is there some way that I can merge the former Backup with the new installation's database?

View 1 Replies View Related

Unable To Restore Backup Database In Sql Server 2005

Oct 5, 2007

I am using sql server 2005 and unable to restore backup file(.bak) file when i ry to restore it to other database it shows following error


restore failed for server (microsoft.sqlserver.smo)
additional information:
system.data.sqlclient.sqlerror : the media set has 2 media families but only 1 are provided.All members nust be provided.(microsoft.sqlserver.smo)

View 1 Replies View Related

Sql2005 Database Restore From Another Sql2005 Backup File Error.

Dec 15, 2005

hi

i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :

 

 

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


 

 

 

pls some one can help me ???

 

thanks

chaus

View 62 Replies View Related

How To Restore A Database From Backup With A Splitted Backup File

Apr 1, 2008

I should restore a SQL Server 2005 Database from backup. The backup contains three files, named user.bak0, user.bak1 and user.bak2.

How is the syntax of the restore filelistonly and the restore database ... ?

I usualy write
restore filelistonly from disk = 'path and filenam.bak'
restore database. zy
from disk = 'path and filename.bak'
with replace,
move.....
move....

This works but I cannot use it with a splitted backup file. The files are much too big to put together to one file.

Thanks in advance for any help.

View 3 Replies View Related

How To Restore Sql Server 2000 Db Backup Into Sql Server 2005 Express Edition

Jun 22, 2007

Hi Friends,I have installed SQL server 2005 Express Edition and SQL Server managementI have a SQL server 2000 db backup file. I try create a new database in my SQL server 2005 express Edition and try restore that backup file from device, it only searching for file with *.bak and *.tm extension! I tried generate backup file with .bak extension and tried restore into SQl server 2005 express edition but still it is not allowing to do so! I also tried copy my database's data file and log file and paste it under SQL server 2005 express edition Data folder and still not able to read the tables.Is that any ways to do restoring for this SQL server 2000 backup file into SQL server 2005 express edition! Anybody can help me on this please...:eek:

View 2 Replies View Related

How To Restore A Sql Server 2005 Database Backup To Sql Server 2000

Oct 17, 2006

Hi All

This is a very urgent requirement of my client having 200 stores and one Head office. the HO has just installed SQL-Server 2005, The HO sends small backups of the data related to stock transfer which needs to be restored at stores. It was working find when both the HO and stores were SQL-Server 2000. but the process has come to a dead halt as the HO has SQL-Server 2005. It is not possible to convert the stores immediately. please help me out.



Thanks

Raoshan

View 3 Replies View Related

Restore Backup From SQL Server 2000 In SQL Server 2005?

Jan 29, 2008

I was running Small Business Server 2003 with MS SQL Server 2000. I put backups of all my SQL Server 2000 databases on hard disk d: and the operating system and applications on c:/. I then reformatted c:/ (but left d:/ intact) and installed Windows XP Home. Then I installed MS SQL Server 2005 Developer's Edition.

I would like to now restore the backups of the SQL Server 2000 databases (still intact on drive d:/) to SQL Server 2005, but I get a variety of error messages.

I suspect that I am going about this the wrong way. I have done several hours of research in the documentation without success. I cannot attach the SQL Server 2000 database to SQL Server 2005 because it is a backup, not a database. I cannot migrate the databases as part of the installation of SQL Server 2005 because (a) they are back-ups, and (b) I don't have SQL Server 2000 installed when I install SQL Server 2005.

Is there a solution?

TIA

Mark Schreiner

View 6 Replies View Related

DB Engine :: How To Restore From Current LDF Log File And Old BAK Backup File

Jun 11, 2015

My customer got a total hard drive failure.After sending it to drive recovery specialist we were able to recover the LDF log file (MyDB_0.LDF).But the MDF file was completely destroyed (MyDB.MDF).They have a good full backup from a month ago.

1) Installed SQL Server 2012 on a new PC
2) Created a new database of same name (MyDB) - with same MDF and LDF file names as original
3) Took the new database offline
4) deleted the MDF and LDF files of the new database
5) put "MyDB_0.LDF" in the place of the LDF file I just deleted 
6) put the database back on-line
7) after hitting F5 to refresh databases - it shows "MyDB (Recovery Pending)"
8) tried to do Tail Log Backup with this command
   BACKUP LOG [MyDB] TO DISK = N'C:BACKUPMyDB_TailLog.bak'
WITH NO_TRUNCATE

And I get this error...

Msg 3447, Level 16, State 1, Line 3
Could not activate or scan all of the log files for database 'MyDB'.

The sad thing is I know we can get this data back using ApexSQL-Log. I can see all the transactions since the last full backup in this program - so the log file is not damaged. But my client doesn't want to pay the $2000 fee for this software.There has to be a way to restore this data, without having to purchase a third party tool.

View 13 Replies View Related

Restore A SQL Server 2005 X64 Backup To SQL Server 2005 X86

Oct 22, 2007

Hello everybody,

I would like to know if it's possible to restore a x64 Backup on a SQL Server 2005 32-bits.
I have found no options during the backup under SQL Server 2005 x64 to allow the compatibility for x86.

Thanks you in advanced for future answers.
Regards,
Flore.

View 3 Replies View Related

Restore Backup File

Oct 12, 2006

I tried to use backup and restore database tasks to restore backup file but it does not work. The backup file I tried to restore in SQL server 2000 is from somewhere else (from my friend) and saved in cd-rom, not the one I created before.
How can I restore it to view in SQL server 2000 database?
Can you show me step by step?
Thanks for your help

View 14 Replies View Related

Restore LDF File After Restoring Backups In SQL Server 2005?

Aug 22, 2007

I'm working on a restore procedure for the case where all MDF filesare missing, but the LDF files are all intact. A full backup is doneevery 24 hours, and a log backup is done every 3 hours. Afterrestoring the last full + log backups, is it at all possible to usethe LDF files to recover data from that point up to a newer point intime?I've found a post which explains how to do this on SQL Server 2000<http://groups.google.com/group/comp...s.ms-sqlserver/browse_thread/thread/3ef5c7cbc0a83334/f3b0c70811d35ed7>, but step 4fails with the following error message:BACKUP LOG cannot be performed because there is no current databasebackup.

View 2 Replies View Related

Restore A Database On Clustered Server From A Non-clustered Backup File.

Aug 24, 2006

Hello,

How do I restore a sql database that is on a clustered server from a sql database backup file that is on a non_clustered server?

Thanks,



Serey

View 3 Replies View Related

Can&#39;t Restore A Backup From File On Sqlserver 6.5

Oct 14, 1999

I have a production SQLServer 6.5 on Nt 3.51 SP4
that had problems two weeks ago, an I had
to restore the backup of the previous night.

we are testing our disaster recovery procedures
on another server, identical to the production
one.

We have installed NT 3.51 SP 4 and SQLServer 6.5
in the same order and with the same configuration
of the production server,
but i can't restore on the test server the
backup files that i have succesfully resotred
on the production server.

we make the SQLServer back up on file ( and
then we backup those files on tape with
NT backup) so I don't think is a problem
of HW Tape Bios or Compression because
i have tried to resotre directly the
files without taking them from a tape.

1)
I have created a new database , without data,
with the same devices, in megabyte, that I
have on the production server.
than from enterprise manager I have started
the restore from file, and after two seconds
everything stops, and I can't even shutdown
the task but i MUST turn the server off
using the power button.

when I start the server again there are
no specific errors in the event log nor
in the SQLServer error log.
The db i was trying to restore is marked
"loading" and it is not available.

This same procedure works perfectly
on the production server.

2)
I have then created another db on the test
server, and I have succesfully tranferred
( but not resotred) the produciont db
onto the test one, using the transfer menu
on SQLEnterprise manager.

3)
another strange thing is that I have tryed
to expand the tempdb, which is only 2 mega
by default, but whenever i try to expand it,
using enterprise manager, only the LOG area
of tempdb sucessfully expands, not the data area.
I don't know if this behaviour is related
to the unsuccesfull restore or if
it is another problem.

i have checked the sort order and character set
of the 2 servers and they are the same.

thanks in advance for any help.

Eugenio La Mesa
Publisoft
Italy

View 1 Replies View Related

Restore Tranlog Backup File

Jan 16, 2007

I have 2 questions, and I appreciate if somebody can help me to figure out the good way to do. Thanks a lot.

1/. If I want to restore tranlog backup file from linked server to SQL Server 2000, Is the database online or offline during that time (since I want to make sure db online for users, but not offline)

2/. Can I restore tranlog backup file from SQL Server 2000 to SQL Server 2005 database?

View 14 Replies View Related

Restore Database From Backup File

May 4, 2015

Now i must restore a database from a backup file of MS SQL Sever 6.5,but this file is bad. When i restore database from this file, SQL Server tell me that the format of this file is not file format of SQL Server 6.5.So that I must repair this backup file firstly. I don't know database file format of SQL Server 6.5.

View 2 Replies View Related

Can I Restore Only A Table From A Backup File?

Nov 24, 2006

Hi,

i have a backup file , and i saw the wizard to restore the file in sql2005.

But i need to restore only a table.

Is there a wizard for that?

View 11 Replies View Related

Restore One Table In Database Use Backup File

May 6, 2008

hi

can you posible one tabel restore in database using full backfile

thanks

View 1 Replies View Related

Create Restore Command From DB Backup File

Sep 7, 2006

This script will read the contents of a DB backup file, and generate a restore command.

Set the value of parameter @backup_path to point to the backup file, run in Query Analyzer, cut/paste the output into another Query Analyzer window, modify as necessary, and run.

This is just a barebones script to demo how this can be done. Modify as necessary to meet your own needs.

Works in SQL 2000 and 7.0. May work in SQL 2005, but it is not tested.


-- Create Restore Database Command from DB Backup File

set nocount on
go

declare @backup_path nvarchar(500)
select @backup_path =
-- Path to Backup file
'\SERVERNAMESHARE_NAMEMY_DB_BACKUP_FILENAME.BAK'


create table #header (
BackupNamenvarchar(128)null,
BackupDescriptionnvarchar(128)null,
BackupTypeintnot null,
ExpirationDatedatetimenull,
Compressedintnot null,
Positionintnot null,
DeviceTypeintnot null,
UserNamenvarchar(128)not null,
ServerNamenvarchar(128)not null,
DatabaseNamenvarchar(128)not null,
DatabaseVersionintnot null,
DatabaseCreationDatedatetimenot null,
BackupSizedecimal(28,0)not null,
FirstLsndecimal(28,0)not null,
LastLsndecimal(28,0)not null,
CheckpointLsndecimal(28,0)not null,
DatabaseBackupLsndecimal(28,0)not null,
BackupStartDatedatetimenot null,
BackupFinishDatedatetimenot null,
SortOrderintnot null,
CodePageintnot null,
UnicodeLocaleIdintnot null,
UnicodeComparisonStyleintnot null,
CompatibilityLevelintnot null,
SoftwareVendorIdintnull,
SoftwareVersionMajorintnull,
SoftwareVersionMinorintnull,
SoftwareVersionBuildintnull,
MachineNamenvarchar(128)not null,
Flagsintnull,
BindingIDuniqueidentifier null,
RecoveryForkIDuniqueidentifier null,
Collationnvarchar(128)null,
Seqintnot null
identity(1,1),
)

create table #filelist (
LogicalNamenvarchar(128)not null,
PhysicalNamenvarchar(128)not null,
Typenvarchar(10)not null,
FileGroupNamenvarchar(128)null,
Sizedecimal(28,0)not null,
MaxSizedecimal(28,0)not null,
Seqintnot null
identity(1,1),
)

insert into #header
exec ('restore HeaderOnly from disk = '''+@backup_path+''' ')

insert into #filelist
exec ('restore FilelistOnly from disk = '''+@backup_path+'''')

declare @tab varchar(1), @cr varchar(2)
select @tab = char(9), @cr = char(13)+Char(10)

select
[--Restore--]=
case
when a.Seq = 1
then
@cr+
@cr+'restore database '+c.DatabaseName+
@cr+'from disk ='+@cr+@tab+''''+
@backup_path+''''+@cr+'with'+@cr
else ''
end+
@tab+'move '''+a.LogicalName+
'''to '''+a.PhysicalName+''' ,'+
case
when a.Seq = b.Seq
then
@cr+@tab+'replace, stats = 5 , recovery'
else ''
end
from
#filelist a
cross join
( select Seq = max(b1.Seq) from #filelist b1 ) b
cross join
( select DatabaseName = max(c1.DatabaseName)
from #header c1 ) c
order by
a.Seq
go
drop table #header
drop table #filelist

Results, modify as needed:

--Restore--
--------------------------------------------------------------------

restore database MY_DB
from disk =
'\SERVERNAMESHARE_NAMEMY_DB_BACKUP_FILENAME.BAK'
with
move 'PRIMARY'to 'D:MSSQLDATAMY_DB_PRIMARY.MDF' ,
move 'DATA1'to 'D:MSSQLDATAMY_DB_DATA1.NDF' ,
move 'DATA2'to 'D:MSSQLDATAMY_DB_DATA2.NDF' ,
move 'LOG'to 'D:MSSQLDATAMY_DB_LOG.LDF' ,
replace, stats = 5 , recovery








CODO ERGO SUM

View 4 Replies View Related

Default File No For Backup Set In Restore Database

Dec 30, 2007

I am confused regarding why the default behavior of this option is to use file no 1 if the option is not specified? If I take two backups on different days, weeks, months, etc. and write them to the same Backup set, the second and most recent backup by the way gets the higher file number (position) as one would expect. What is incomprehensible to me is why the decision was made to restore the oldest backup from the backup set if you do not specify with file no? Seems like common sense that I would NEVER want to restore the oldest backup by default and would most-likely always want to restore the most recent backup by default!

If anyone has suggestions on how I could suggest that the behavior of this option be changed, I would appreciate it, as this has caused me much pain.

Tim

View 2 Replies View Related

Differential Backup File Fails To Restore.

Jul 19, 2007

We are doing the following steps:-

1. Weekly Full Bckup

2.Daily Differential backup

3.hr Log back up

The following command works fine for all the Backups. it means backup file is fine.

RESTORE FILELISTONLY from DISK = 'D:BackupewDB_ full.BAK'

RESTORE HEADERONLY FROM DISK = 'D:BackupewDB_ ull.BAK'

RESTORE LABELONLY FROM DISK = 'D:BackupewTest_full.BAK'

RESTORE VERIFYONLY FROM DISK = 'D:BackupewTest_full.BAK'



Also The full back up restoration works fine:

RESTORE DATABASE Test3 FROM DISK = 'D:BackupewTest_full.BAK'

WITH MOVE 'Test2_Data' TO 'F:MSSQL2KMSSQLdataTest2Net_Data.MDF',

MOVE 'Test2_Log' TO 'F:MSSQL2KMSSQLdataTest2Net_Log.LDF',

NORECOVERY

GO

/* RESULT :

Processed 1032 pages for database 'Test3', file 'test2_Data' on file 1.

Processed 1 pages for database 'Test3', file 'test2_Log' on file 1.

RESTORE DATABASE successfully processed 1033 pages in 1.907 seconds (4.433 MB/sec).

*/

But While restoring the Differential file it throws error:

RESTORE DATABASE Test3 from DISK = 'D:Backupew est2_Diff1.bak'

WITH NORECOVERY

GO



Msg 3136, Level 16, State 0, Line 1

Cannot apply the backup on device 'D:Backupew est2_Diff1.bak' to database 'Test3'.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

I checked the SQL Server Log no error msg corresponding Differential backup restore.



I don't know how to proceed further.Can any one guide me how to over come this..



Thanks !

View 2 Replies View Related

SQL Server 2005 Restore Error!

Aug 18, 2006

Hi Team,
I try to restore my local database using the backup from the live server. However I encountered this type of error:
====================================================================
System.Data.SqlClient.SqlError: The path 'C:Microsoft SQL ServerFullTextApplication_FullText' has invalid attributes. It needs to be a directory. It must not be hidden, read-only, or on a removable drive. (Microsoft.SqlServer.Smo)
====================================================================
It worked before I added a full-text search feature. Any idea?
Thanks in advance.

View 15 Replies View Related

SQL Server Admin 2014 :: Restore DB With Full Backup And Transactional Log Backup

Aug 3, 2015

Need to restore database,here's the scenario:

Data got deleted on Friday evening, need to have database restored to FRiday afternoon and also some data has been entered on Monday, which needs to be there.

View 8 Replies View Related

Loading/Suspecting When I Tried To Restore Database Through Backup File.

Jun 15, 2004

I can run this example from SQL Book Online from sql query analyzer. I can build the TestDB database.

BACKUP DATABASE Northwind
TO DISK = 'c:Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:Northwind.bak'
WITH MOVE 'Northwind' TO 'c: est estdb.mdf',
MOVE 'Northwind_log' TO 'c: est estdb.ldf'
GO

But... When I build stored procedure and call it through VB6. I've got the gray database symbol along with message TestDB (Loading/Suspecting)
Why I cannot run these commands through VB6

View 1 Replies View Related

Restore To New Db Restores Less Data Than What Is In The Source Backup File

Jan 25, 2006

I am trying to create sql code that restores a backup of a master database to a new database on the same server. It “seems” to run correctly as no errors are produced. However, the most recent updates to the master database are not present in the new databases. All databases are using the Full recovery model. What is really strange is that if I do (what I think is) the same function in Enterprise Administrator, the restore works fine! For both methods I used the same backup file!



Any and all help is sincerely appreciated.


The master databases from which the backups are made start with “MODTRNMaster”

The databases which are created from the restores start with “M1_” and “M2_”. (We call them training room databases.)



My script for backing up the master databases:



-- Backup the master training database

backup database MODTRNMaster
to disk = 'f:kupMODTRNMaster.bak'

backup database MODTRNMaster_IMG
to disk = 'f:kupMODTRNMaster_IMG.bak'

backup database MODTRNMaster_MNC
to disk = 'f:kupMODTRNMaster_MNC.bak'

backup database MODTRNMaster_VM
to disk = 'f:kupMODTRNMaster_VM.bak'

go


This is the restore script for restoring the first training room databases. I’m hoping that there is just something simple that I’m overlooking in these restore statements! J



-- Restore the backup of the master training database into the

-- training room #1 database.

use master
go

drop database M1_MSLH
go


restore database M1_MSLH
from disk = 'f:kupMODTRNMaster.bak'
with move 'DEV5_Data' to 'f:mssqldataM1_MLSH.mdf',
move 'MM' to 'f:mssqldataM1_MLSH_1.mdf',
move 'AMB' to 'f:mssqldataM1_MLSH_2.mdf',
move 'DM' to 'f:mssqldataM1_MLSH_3.mdf',
move 'IMM' to 'f:mssqldataM1_MLSH_4.mdf',
move 'ED' to 'f:mssqldataM1_MLSH_5.mdf',
move 'DEV5_Log' to 'f:mssqllogM1_MLSH_log.ldf',
recovery

go



Thanks in advance

:eek:

:eek:

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved