Solved

Can't Restore Vault Database

Posted on 2008-10-13
13
558 Views
Last Modified: 2011-10-19
I'm new to Databases so this may appear to be a silly question
Basically I want to move Vault (4.11) from one server to another.
So far I have installed the latest version of Vault (4.13) onto the new server and I have successfully backed up the two required Databases on the current installation of Vault (sgmaster & sgvault) and copied them to the new server.
I have entered the Serial Nos. from the old Server onto the new Server, but when I go to do a restore, it says there is nothing to restore and I have since read that I need to Import them into SQL 2005, but I don't know how to do this.

My question quite simply is how do I import the Vault backup database to SQL 2005 and then restore it to Vault.

Thanks in advance for any help.
0
Comment
Question by:Steveh24
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 22710727
From a quick web search you are talking about the SourceGear Vault product (versioning for development like Microsoft Visual SourceSafe (VSS)), which is a separate item from the databases and SQL Server 2005 or which ever SQL version you are using:

MSDE 2000 (SP3a), SQL Server 2000 (SP3a), SQL Server 2005 (SP1), or SQL Server Express 2005 (SP1)
http://sourcegear.com/vault/sysreq.html

What you need to do is go into the SQL 2005 Management studio. Under the databases window right-click and Restore Database. Find the backup files and then walk through restoring.
0
 

Author Comment

by:Steveh24
ID: 22711160
I tried this already but there are a couple of things I don't understand, first the name of the restore file that I have selected that appears in the Restore Wizard says **** Incomplete **** and secondly when I try to do the restore I get a message saying that the backup set  holds a backup of a database other than the existing sgvault database.

0
 

Author Comment

by:Steveh24
ID: 22711311
I should also mention that when I did the backup of the current Vault database, it gave it an extension of .sgvbak, which wasn't recognised by the SQL 2005 Restore wizard, so I added .bak to the end of it so it could be seen
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
LVL 38

Expert Comment

by:Jim P.
ID: 22711571
Let's start from the beginning.

On the original server open a query analyzer window and run the first set of commands to backup the databases. Change paths and names as needed.

Then copy the bak file(s) to server B

Then assuming your paths have changed from server A to server B run the "restore filelistonly" commands to get the logical filenames. Change them and the paths as appropriate. Then run the restore command.
BACKUP DATABASE [AdventureWorks] 
	TO  DISK = 'D:\MyPath\AdventureWorks.bak' 
	WITH NAME = 'AdventureWorks-Full Database Backup', 
	STATS = 5
GO
RESTORE VERIFYONLY FROM  DISK = N'D:\MyPath\AdventureWorks.bak' WITH  
GO
----------------------------------------------------
restore filelistonly 
	from disk='D:\MyPath\AdventureWorks.bak' 
 
 
/************ Remove the slash and asterisks to uncomment this text
 
RESTORE DATABASE [AdventureWorks] FROM  
	DISK = 'D:\MyPath\AdventureWorks.bak' 
	WITH  
	MOVE 'Logical_FileName_Data' TO 'E:\MyPath\AdventureWorks.mdf',  
	MOVE 'Logical_FileName_log' TO 'E:\MyPath\AdventureWorks.ldf',  
	NOUNLOAD,  REPLACE,  STATS = 5
GO
*****************/

Open in new window

0
 

Author Comment

by:Steveh24
ID: 22758411
Sorry for the delay in replying but I've been away on business.

I have a major problem with your solution, which will work, but I don't have the SQL 2005 Management studio installed and I have tried to install it using sqlRun_Tools.msi on Disk 2 of the SQL 2005 installations disks, but it keeps saying that it is installed, but there is nothing in the dir Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE

If I try to install the tools from the install CD I get an error message about an Instance Error.

Help, how can I install the SQL 2005 Management studio.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22758694
Instead of going for the tools only try doing it from the full setup and go through all the steps only selecting install tools and don't install the sample databases.

If that doesn't work then try from the add/remove programs.

The last option is going through the registry and deleting all the Microsoft SQL Server and MSSQLServer references and try another install.

Note that this is assuming it is from your workstation you are having these problems.
0
 

Author Comment

by:Steveh24
ID: 22765299
As I mentioned in my last reply, I have tried to install the tools from the full setup and from Add/Remove Programs, but I get a "Change of Edition Error" using both and if I ignore this error and continue, any components I try to install or even remove are blocked.

Is there any other way to install the SQL 2005 Management studio ??

0
 

Author Comment

by:Steveh24
ID: 22765303
How can I tell what version of SQL 2005 I have installed
0
 

Author Comment

by:Steveh24
ID: 22765609
Ok, problem solved, I was so intent on trying to get the tools installed on the server, that I overlooked the possibility of installing them on my PC, which is what I've done and then connected to the Server I want to do the backup.

When you backup a database using SQL 2005 Management Studio, do I need to disable any of the services ie. how can I ensure that the database is not being used while doing the backup.
0
 

Author Comment

by:Steveh24
ID: 22766303
Ok, I've successfully completed a Backup of the sgvault database, but I noticed that it was not given any file extension, so I have added .bak and copied it to the new server vault server and tried to restore it using SQL 2005 Management Studio, but i'm getting the same error as before, the backup set  holds a backup of a database other than the existing sgvault database
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 125 total points
ID: 22766692
How did you do the backup -- via the GUI? Or a New Query window using the commands like those above?

>> how can I ensure that the database is not being used while doing the backup.

The SQL backup is smart enough that if some transaction is running during the backup that it looks at the checkpoints. If a transaction is running as the backup finishes it looks at the current checkpoint again and will commit the change to the backup or mark it for rollback during the restore.

>> the backup set  holds a backup of a database other

That error comes from the prior DB being there. If you are using the command line the the WITH REPLACE will overwrite the existing DB. From the GUI On the Options you select Overwrite Existing Database
Restore-GUI.jpg
0
 

Author Comment

by:Steveh24
ID: 22813512
I have installed SQL 2005 Management Studio on my PC and backed up the current Vault database and restored it to new SQL server using the Overwrite oprion and everything has worked successfully.

Many thanks for your help
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22813675
Can I ask why a B grade?


What's the right grade to give?
http://www.experts-exchange.com/help.jsp#hi403
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question