Solved

Can't Restore Vault Database

Posted on 2008-10-13
13
541 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
  • 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
 
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Read about achieving the basic levels of HRIS security in the workplace.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

708 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now