HELP! I need to viewing MS Dynamic CRM .BAK

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

HELP! I need to viewing MS Dynamic CRM .BAK

Author

Topic

ron.bush
Starting Member

1 Post

Posted - 2011-09-04 : 09:43:34

I need help viewing Microsoft Dynamic CRM 4.0 .BAK Backup files. I am quite computer savvy, but haven't the first clue about networks or databases.

The backup files were located on a server, they are now on an external hard drive. All i have is a Windows XP prof. laptop and the .bak files.

The files are

Name_MSCRM_backup_201007290000

Name_backup_201109040000

master_backup_2011090400000

ReportServer_backup_201109040000

ReportServerTempDB_backup_201109040000

SharePoint_AdminContent_code_backup_201109040000

SharePoint_Config_backup_201109040000

WSS_Content_code_backup_201109040000

WSS_Content_backup_201109040000

WSS_Content_code_backup_201109040000

When I try and view them with various SQL virtual database software, I only receive errors.

Could someone help me with ideas or a wlakthrough.

I'm ultimately trying to get all the data off to an excel spreadsheet.

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-09-04 : 13:09:41

First thing you need is an installation of SQL Server. The 180 day evaluation will be good enough. Download and install that, then post back.

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2011-09-04 : 14:30:44

Install SQL Server (if not already installed)

Restore the Backup files, each to create a new database - the name of the backup will give you a suggestion for the name of the database.

Do not restore:
master_backup_2011090400000

You probably do not need to restore:
ReportServer_backup_201109040000
ReportServerTempDB_backup_201109040000
SharePoint_AdminContent_code_backup_201109040000
SharePoint_Config_backup_201109040000

Not sure about the WSS ones either ... I don't recognise their names though, so they may be useful.

"When I try and view them with various SQL virtual database software, I only receive errors."

Not sure what tools you are using, but SQL Backup files won't be "viewable", you will need to restore them to a SQL Server.

"I'm ultimately trying to get all the data off to an excel spreadsheet."

Good luck with that! The database will be a complex structure of inter-related tables. Trying to duplicate even a small part of that complexity in something like Excel is going to come a very poor second place ...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-09-04 : 14:39:12

WSS* are sharepoint content DBs (Windows Sharepoint Service). Useless without Sharepoint installed

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2011-09-05 : 03:19:15

So that leaves:

Name_MSCRM_backup_201007290000
Name_backup_201109040000

which are probably the same database? with the first being a backup from 2010, so hopefully Name_backup_201109040000 is the CRM database's backup

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources