Problem Doing SQL 2005 DB Restore

Feb 7, 2007

I did a full DB backup that I am trying now to restore via the SQL Server Management Studio.

I select "Restore" and then "From Device" and point to the bak file that I want to restore from.

I then go into the Options page and check "Overwrite the existing database".

Below that, shows the Restore the database files as

RB_Data_Services_MSCRM

RB_Data_Services_MSCRM_Log

sysft_ftcat_documentindex

When I then click OK I get the following error. The Media Set has 3 Media Families but only 1 are provided. All members must be provided.

Any ideas as to what I did to do to be able to complete this restore?

Thank



Rick Bellefond

View 3 Replies


ADVERTISEMENT

Restore Not Working (2005-&>2005)

Apr 28, 2007

  I did a backup using SQL Server 2005 Express on 1 machine, and when I tried to restore to SQL Server 2005 Developer Edition (included with VS 2005 Pro), it gives me the following error:
TITLE: Microsoft SQL Server Management Studio------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------ADDITIONAL INFORMATION:
The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476
------------------------------BUTTONS:
OK------------------------------
  I looked at the link and it is talking about SQL Server 7 and 2000. I read a few posts about not being able to restore 2005 to 2000, but I have 2005 on both machines. I'm not sure the best way to check, but I know I installed the SQL Server 2005 Developer edition to the new machine recently. Any ideas?
Thanks!

View 1 Replies View Related

Restore From 2005 To 2000

May 28, 2007

Dear experts, I've a backup in sql server 2005. how can i restore that in 2000? and is it possible to do the same from 2000 to 2005?

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 2 Replies View Related

Restore Sql 2000 Bak To 2005

Nov 22, 2006

Hi,I have an old 2000 bak file for a db that I would now like restoredonto sql server 2005. I keep erroring out though, this is what I'mdoing:Went to Restore Database in sql 2005, selected the db I want itrestored to, and File (say c: empxyz.bak)Checked the restore checkbox, went to options checked Overwrite theexisting database.Do I need to do anything else, maybe in the Restore the database filesas section? As those path are listed as:C:Program FilesMicrosoft SQL ServerMSSQLdataxyz.mdfC:Program FilesMicrosoft SQL ServerMSSQLdataxyz_log.ldfIf I just run it without updating those mdf and ldf paths, I keepgetting an error:Exclusive Access could not be obtained because the database is in use.Thanks.

View 2 Replies View Related

How To Restore SQL 2005 DB To SQL 2000

Jan 2, 2006

Hello,

I'm tring to restor a DB from sql 2005 (which is located on my local computer) into sql 2000 (which is located  on the server) and I am getting this type of message:

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

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

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

Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)

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

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

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


Why? and how to restore SQL 2005 DB to SQL 2000?

 

View 49 Replies View Related

Can Not Restore With SQL Serevr 2005

Apr 5, 2008

Dear All,

I need your help, I am trying to restore the data base with SQL Server 2005 Standard Edition. But I am facing errors see below, please help me out. i am really in trouble. I am using Windows XP Media Edition. I am getting this error even I tried to restre the data base after creating a new with over-write check. Quick response will higly be appriciated.

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

System.Data.SqlClient.SqlError: The media family on device 'D:OthersSTOCKGAME ServerLED_STOCK.BAK' is incorrectly formed. SQL Server cannot process this media family. (Microsoft.SqlServer.Smo)


thanks,

Shahbaz Ahmad.

View 8 Replies View Related

SQL 2005 Database Restore

Jul 27, 2006

In SQL 2000, When I restore a database backup called "A" as "B" the datafile name and log file will change automatically with the new restored database name , whereas in SQL 2005 the datafile name and log file name remains with backup database name.

Will this issue be addressed in next release of service pack.









View 4 Replies View Related

How To Restore Master DB In SQL 2005????

Aug 3, 2006

I've tried starting SQL from the command line in single user mode (-m). When I try to open Management Studio I receive an error that it can't connect. Can you only restore master from a command line in SQL 2005? Or can I do it from a GUI?

Thanks,
Mark

View 9 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 2005 Restore Problem

Jun 10, 2008

Hi,I am using SQL Server 2005 Enterprise edition. I face a problem when I want to restore a database. DataDB.mdf is the database file, When i want restore it using Sql server management studio it show the following error.
TITLE: Microsoft SQL Server Management Studio
------------------------------

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

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

The media family on device 'C:DatabaseDataDB.mdf' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

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

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

OK
------------------------------Any suggestions are welcome.Best Regards 

View 1 Replies View Related

Backups And Restore DB In SQL EXPRESS 2005

Jan 23, 2006

can anyone explain me how can i make a  DB backup in sql express 2005 ?
The sql express instance and my web aplication  are running on the same server.
I need a script for directly execute it (and if possible also to restore the DB ) from my web aplication.

other question:
any idea how can i tell to sql express to do the backup automatically every day?

View 1 Replies View Related

How Can I Restore A SQL 2005 Database On My SQL 2000?

Aug 4, 2007

My customer has SQL Server 2005. I have SQL Server 2000 on my laptop (on XP Pro). I believe I have an empty database the same as theirs, but I need to restore their data. They sent me a normal SQL Backup, but my laptop threw a fit and cannot work with it.

They are now trying to export the database to Microsoft Access and send me that, but I won't get that until next week now. However is there a better and easier solution for those of us with insufficient experience of this, please?

Many thanks,
Caspar

View 3 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

Restore Failed In Sql Server 2005.

May 19, 2008

Hi,
I am trying to restore a production copy. I have only the .bak file with me. While restoring, i m facing the following error. can u please help me... thanks in advance.

"MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file."

I have placed the data files(52GB) in D: drive(140GB free space) and transaction log file(100GB) in F: drive(465GB free space). Still i am facing this error...

-- Sudheer

View 8 Replies View Related

Cannot Restore SQL2000 Backup To 2005 (Msg #601)

Jun 5, 2008

Hello,

In the process of migrating a logshipped database (in non recovery mode) from SQL2000 SP4 to SQL2005 SP2, I got the following error (sorry for the french translation!):
---
Conversion de la base de données 'AdStatistiques' de la version 539 à la version actuelle 611.
Base de données 'AdStatistiques' exécutant l'étape de mise à jour de la version 539 à la version 551.
Msg 601, Niveau 12, État 3, Ligne 1
Impossible de poursuivre l'analyse avec NOLOCK car les données ont été déplacées.
Msg 3167, Niveau 16, État 1, Ligne 1
RESTORE n'a pas pu démarrer la base de données 'adstatistiques'.
Msg 3013, Niveau 16, État 1, Ligne 1
RESTORE DATABASE s'est terminé anormalement.
---

Of course, the restore operation performs well when the destination is SQL2000. I suspect the integrity checker of SQL2005 to be less permissive, hence I run a checkdb on the original DB, which raise several errors, which are quite difficult for me to analyse:
[Sorry, it's in french again]
----
Serveur : Msg 8929, Niveau 16, État 1, Ligne 1
Objet ID = 2 : Erreurs trouvées dans le texte ID = 15620702208 possédé par l'enregistrement de données identifié par RID = (1:1385:13) id = 1902629821 and indid = 1.
Serveur : Msg 8929, Niveau 16, État 1, Ligne 1
Objet ID = 2 : Erreurs trouvées dans le texte ID = 15620767744 possédé par l'enregistrement de données identifié par RID = (1:1385:14) id = 1902629821 and indid = 2.
Serveur : Msg 8929, Niveau 16, État 1, Ligne 1
Objet ID = 2 : Erreurs trouvées dans le texte ID = 15620833280 possédé par l'enregistrement de données identifié par RID = (1:1385:15) id = 1902629821 and indid = 3.
Serveur : Msg 8929, Niveau 16, État 1, Ligne 1
Objet ID = 2 : Erreurs trouvées dans le texte ID = 15620898816 possédé par l'enregistrement de données identifié par RID = (1:1385:16) id = 1902629821 and indid = 4.
Serveur : Msg 8929, Niveau 16, État 1, Ligne 1
Objet ID = 2 : Erreurs trouvées dans le texte ID = 26594574336 possédé par l'enregistrement de données identifié par RID = (1:7153632:27) id = 1031010754 and indid = 5.
Serveur : Msg 8961, Niveau 16, État 1, Ligne 1
Erreur de table : Objet ID = 2. Le nœud text, ntext ou image à la page (1:1974), slot 0, texte ID = 26594574336 ne correspond pas à sa référence dans la page (1:191177), slot 10.
Serveur : Msg 8974, Niveau 16, État 1, Ligne 1
Nœud texte référencé par plusieurs nœuds. L'objet ID = 2, page de nœud text, ntext ou image (1:1974), slot 0, texte ID = 26594574336 est pointé par la page (1:191177), slot 10 et par la page (1:38504), slot 0.
Serveur : Msg 8965, Niveau 16, État 1, Ligne 1
Erreur de table : Objet ID = 2. Le nœud text, ntext ou image à la page (1:1111184), slot 0, texte ID = 15620767744 est référencé par la page (1:191177), slot 11, mais n'a pas été vu à l'analyse.
Serveur : Msg 8965, Niveau 16, État 1, Ligne 1
Erreur de table : Objet ID = 2. Le nœud text, ntext ou image à la page (1:1111185), slot 0, texte ID = 15620833280 est référencé par la page (1:191177), slot 12, mais n'a pas été vu à l'analyse.
RĂ©sultats DBCC pour 'AdStatistiques'.
RĂ©sultats DBCC pour 'sysobjects'.
Il y a 388 lignes dans 9 pages pour l'objet 'sysobjects'.
RĂ©sultats DBCC pour 'sysindexes'.
Serveur : Msg 8965, Niveau 16, État 1, Ligne 1
Erreur de table : Objet ID = 2. Le nœud text, ntext ou image à la page (1:1111186), slot 1, texte ID = 15620898816 est référencé par la page (1:1385), slot 16, mais n'a pas été vu à l'analyse.
Il y a 437 lignes dans 26 pages pour l'objet 'sysindexes'.
CHECKDB a trouvé 0 erreurs d'allocation et 10 erreurs de cohérence dans la table 'sysindexes' (objet ID = 2).
[SNIP]
RĂ©sultats DBCC pour 'AdStatPageHeure_OLD'.
Serveur : Msg 8977, Niveau 16, État 1, Ligne 1
Erreur de table : Objet ID = 1902629821, index ID = 1. Le nœud parent pour la page (1:1043307) n'a pas été rencontré.
Serveur : Msg 8977, Niveau 16, État 1, Ligne 1
Erreur de table : Objet ID = 1902629821, index ID = 1. Le nœud parent pour la page (1:1043308) n'a pas été rencontré.
Serveur : Msg 8977, Niveau 16, État 1, Ligne 1
Erreur de table : Objet ID = 1902629821, index ID = 1. Le nœud parent pour la page (1:1043309) n'a pas été rencontré.
Serveur : Msg 8977, Niveau 16, État 1, Ligne 1
[SNIP, several errors pretty similar here]

-Trop d'erreurs trouvées (201) pour l'objet ID = 1902629821. Pour voir tous les messages d'erreurs, relancez l'instruction avec 'WITH ALL_ERRORMSGS'.
Il y a 21062117 lignes dans 72062 pages pour l'objet 'AdStatPageHeure_OLD'.
CHECKDB a trouvé 0 erreurs d'allocation et 72063 erreurs de cohérence dans la table 'AdStatPageHeure_OLD' (objet ID = 1902629821).
---

Of course, I'd like to delete the AdStatPageHeure_OLD table but I get a cryptic error message when doing that, and I can't remove the indexes that, according to some other posts I browsed, could explain the behavior:
---

La page (1:1111186), slot 1 pour le noeud text, ntext ou image n'existe pas.
Page (1:1111186), slot 1 for text, ntext, or image node does not exist. (Microsoft SQL Server, Erreur : 7105)

Pour obtenir de l'aide, cliquez sur : http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=7105&LinkId=20476
---


Is there any easy option you can see to operate the transfer, since the backups I have from the DB already contain the data corruption?

Thanks a lot for any hint you could provide,
--
Julien

View 2 Replies View Related

SQL 2000 DB Backup Restore To SQL 2005 DB

Jun 10, 2008

Friends -

Is it possible to restore user databases in SQL Server 2005 with user database backup copy of SQL Server 2000.

Please advise on this.

Cheers:)
VSH

View 11 Replies View Related

2005 Express Restore Error

Aug 24, 2006

From everything I'm reading, I shouldn't be getting this error in 2005: Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)
I have both SQL Server 2000 and SQL Server 2005 (Express) on same dev box, have loaded SP 4 for 2000, I'm trying to restore this in 2005.
Why am I still getting this error?
Help is appreciated greatly. Thanks.
Sheryl

View 2 Replies View Related

Restore Fail In Sql Server 2005

Jan 8, 2007

Posted - 09/07/2005 : 15:32:52
--------------------------------------------------------------------------------

Hi, i need help about restore a DB
I did a backup of a database using SQL Server Management Studio, but when i try to restore my database now, i get this error:

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

Restore failed for Server 'Athenas'. (Microsoft.SqlServer.Smo)

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)

What do i doing so bad??
Thanks for ur opinions and help.
Regards
------------------------------------------


seyha moth

View 8 Replies View Related

SQL 2005 Backup To Restore In SQL 2000 SP3

Feb 15, 2007

Hi All
I have a problem in transferring a 2005 backed up database to SQL Server 2000 SP3.
i got an error message, crux of it is
"too many backup devices specified only 64 allowed"

the i browsed MICROSOFT help, downloaded SQL 2000 SP4 - mentioned as a fix for the above error.

Now get a message,crux of it is
"current version of Database in 611 and destination version is 536"

Is there a solution????
should i download any other patches or
Should i tweak the SQL 2005 backup process???
ASAP Plz

View 1 Replies View Related

Can I Restore SQL 2005 Backup On SQL2000

May 10, 2007

Hi all

i have taken backup of a database from SQL Server2005
can i Restore it on SQL Server2000 server?

Please help me

Thanks

View 2 Replies View Related

Backup SQL 2000 SP4 And Restore On SQL 2005

May 26, 2006

Does anyone know if this works to where the data is viewable/usable?



I have an application that takes datasets out of the SQL database. We decommisioned our old SQL 2000 SP4 machine and brought in a SQL 2005 Server. What we did was backed up the old database and then restored it on the new Server.

Now the application does not see the old datasets but will collect new ones that are viewable. We can import older datasets but we have nearly 27 GB of data, which our DBA can see the old tables in Enterprise Manager but our applciation can't see it.

I'm thinking it might be a schema issue or the way that 2005 translate the odler 2000 SP4 database. Does anyone know, or have they run a back up on a older 2000 Server and then restored it to a 2005?

Thank you.

David

View 4 Replies View Related

Can I Restore Sql 2000 From Veritas Under Sql 2005?

Nov 14, 2006

While ago my SBS 2003 which had SQL 2000 crashed so I had to rebuild everything and this time I used SBS 2003 R2. My SQL 2000 databases were backed up under Veritas 10 and now I'm trying to restore them under SQL 2005. Is this possible?

Please advice.

Thanks,

Mike

View 4 Replies View Related

SQL Server 2005 - Restore Problem

Jun 27, 2007

Hello People,



I´ve backup my databases into a Tape Device that wa named as [Tape Device].

I´m using a job to perform this action.



Basically I´ve do a Full backup to this tape and apprently it´s working fine.

The problem is when I´m trying to perform a restore.



I´m using MSMS to perform this restore.

I´m tryin to see the contenct of the Tape and I´m getting this error:



===================================

System.Data.SqlClient.SqlError: Cannot open backup device 'Tape Device(\.Tape0)'. Operating system error 32(error not found). (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteWithResultsAndMessages(String cmd, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSqlWithResults(Server server, String cmd)
at Microsoft.SqlServer.Management.Smo.Restore.ReadMediaHeader(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.BakDevMediaContents.InitMediaInfo(Restore sqlRestore)
at Microsoft.SqlServer.Management.SqlManagerUI.BakDevMediaContents.InitProp()


Additional informations:

- I´m logged on MSMS under a local Admin Account

- My SQL Server agent are using a System Account

- SQL Server 2005 SP1



I´ll really appreciate for any help.



Thanks,



José D. Lima

View 7 Replies View Related

Restore DB On SQL 2005 Multiple Files

Apr 9, 2007

Hello,

I have a SQL 2000 DB. Current tables in sql 2000 DB are in single file. I am planningto migrate the DB to sql 2005. I am going to partition the tables in sql 2005 and have multiple files. What is the best way to do this? Would backup/restore work? If I restore onto sql 2005 from sql 2000 backup, will the tables spread over different files automatically or not? Any ideas will be appreciated...

Thanks........

View 1 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 2005 Backup To 2000 Restore

Jul 9, 2007

I need to restore a backup of database taken from SQL 2005 in SQLServer 2000.



I tried to restore from backup file; It says "Error 3205: Too many backup devices specified for backup or restore; Only 64 are allowed" .



I tried to attach mdf file, it too failed.



Can anyone help me in the procedure to restore 2005 backup in 2000?



View 4 Replies View Related

Restore A SQL 2005 Database On SQL 2000

Aug 13, 2006

Hello,

If I have a SQL 2005 database set to SQL 2000 Compatiblity can I create a backup on SQL 2005 that can be restore on SQL 2000.

Michael

View 1 Replies View Related

Restore Fails Between 2005 Servers

May 9, 2008

Get the following error when trying to restore from one SQL 2005 server (64-bit, standard edition) to another (32-bit, enterprise edition).


Msg 3169, Level 16, State 1, Line 1

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

View 3 Replies View Related

Can I Restore Sql 2000 From Veritas Under Sql 2005?

Nov 14, 2006

While ago my SBS 2003 which had SQL 2000 crashed so I had to rebuild everything and this time I used SBS 2003 R2. My SQL 2000 databases were backed up under Veritas 10 and now I'm trying to restore them under SQL 2005. Is this possible?

Please advice.

Thanks,

Mike

View 1 Replies View Related

Backup MS SQL 2005 -&&> Restore MS SQL 2000

Feb 9, 2007

hi there

i've made a backup from a MS SQL Server 2005 database and i tried to restore this database to a MS SQL Server 2000. Unfortunately, I got following error

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrad this database.

what can i do ? is it possible to restore the MS SQL Server 2005 DB on a MS SQL Server 2000 ?

Philipp

View 4 Replies View Related

Sql Server 2005 Restore Failure

Aug 28, 2006

Hi,

I have a SQL Server 2005 Database that I would like to export to SQL Server Express.

How do I go about this?

I've tried backing it up, creating a new (blank) SQL Server Express Database and trying to restore it, but get the following message
------------------------------

Restore failed for Server 'PRODSOL-LAPTOP1SQLEXPRESS'. (Microsoft.SqlServer.Smo).

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

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'test' database. (Microsoft.SqlServer.Smo)

please help

Regrds

T.Anantha Krishnan

View 1 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

I Need To Restore A SQL 2005 DB To SQL 2000. What Is The Best Method To Do This?

Nov 1, 2007



Hi

I need to restore a SQL 2005 DB to SQL 2000.
What is the best method to do this?

Thanks in advance.

View 6 Replies View Related







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