SQL 2005 Backup Problems
Mar 14, 2007
We have a SQL 2005 server running the following backup job:
EXECUTE master.dbo.xp_create_subdir
N'\ServerBackupsDBServerName\DB_Name__METABASE '
GO
EXECUTE master.dbo.xp_create_subdir
N'\serverBackupsDBServerName\DB_Name__MSCRM'
GO
BACKUP DATABASE [db_name__metabase] TO disk = N'\serverBackups
DBServerName\DB_Name__METABASE
DB_Name__METABASE_backup_200610261158.bak' WITH differential ,
noformat , noinit , name =
N'DB_Name__METABASE_backup_20061026115839' , skip , rewind ,
nounload , stats = 10
GO
DECLARE @backupSetId AS INT
SELECT @backupSetId = position
FROM msdb..backupset
WHERE database_name = N'DB_Name__METABASE'
AND backup_set_id = (SELECT MAX(backup_set_id)
FROM msdb..backupset
WHERE database_name =
N'DB_Name__METABASE')
IF @backupSetId IS NULL
BEGIN
RAISERROR (N'Verify failed. Backup information for database
''DB_Name__METABASE'' not found.',16,1)
END
RESTORE verifyonly FROM disk = N'\serverBackupsDBServerName
DB_Name__METABASEDB_Name__METABASE_backup_200610 261158.bak' WITH
FILE = @backupSetId , nounload , norewind
GO
BACKUP DATABASE [db_name__mscrm] TO disk = N'\serverBackups
DBServerName\DB_Name__MSCRMDB_Name__MSCRM_backu p_200610261158.bak'
WITH differential , noformat , noinit , name =
N'DB_Name__MSCRM_backup_20061026115839' , skip , rewind , nounload ,
stats = 10
GO
DECLARE @backupSetId AS INT
SELECT @backupSetId = position
FROM msdb..backupset
WHERE database_name = N'DB_Name__MSCRM'
AND backup_set_id = (SELECT MAX(backup_set_id)
FROM msdb..backupset
WHERE database_name = N'DB_Name__MSCRM')
IF @backupSetId IS NULL
BEGIN
RAISERROR (N'Verify failed. Backup information for database
''DB_Name__MSCRM'' not found.',16,1)
END
RESTORE verifyonly FROM disk = N'\serverBackupsDBServerName
DB_Name__MSCRMDB_Name__MSCRM_backup_200610261158 .bak' WITH FILE =
@backupSetId , nounload , norewind
This job was set up long before i started here and the problem is that
the backup file itself has grown to be over 230 GB. It does not
appear that the backup job is pruning the file. is there a way to
view the contents of this file and then prune it so we keep no more
then two weeks worth of data.
Thanks
View 1 Replies
ADVERTISEMENT
Dec 5, 2006
What is the difference between "Files aned File Groups" backup and Partial Backup?
Looks like both are same.. Please comment.
View 3 Replies
View Related
Apr 15, 2008
I have only one tape drive.
My server is using the SQL server 2005 backup tool and arcserve backup tool to backup different files .
Everytime I need to disable and enable the tape device driver (in device manager /windows) before I can use SQL server 2005 backup tool.
Everytime I need to disable and enable the tape device driver (in device manager /windows) before I can use arcserve backup tool.
It seems that the tape device resource is held by softwares even the tape drive is not in use.
What should I do to make the tape drive shared by different softwares?
Regards,
Manuel
View 2 Replies
View Related
Apr 23, 2008
Hello,
I would like to ask you if there is better to recreate database structure on 2005 from 2000 and move data or to just load
2000 backup.
Currently I loaded the backup, but I am wondering if there might be slightly better performance on 2005 when recreating structure on 2005 to loading 2000 backup?
Does loading 2000 backup create 2005 binary structure?
Thanks for help in advance
View 5 Replies
View Related
Jan 31, 2008
Hi there
I'm getting this message on my third automated backup of the transaction logs of the day. Both databases are in full recovery mode, both successfully backed up at 01.00. The transaction logs backed up perfectly happily at 01:30 and 05:30, but failed at 09:30.
The only difference between 05:30 and 09:30's backups is that the log files were shrunk at 08:15 (the databases in question are the ones that sit under ILM2007, and keeping the log files small keeps the system running better).
Is it possible that shrinking the log files causes the database to think that there hasn't been a full database backup?
Thanks
Jane
View 3 Replies
View Related
Mar 15, 2007
I have ctreated a maintenance plan to backup a database daily.
The option is set to overwrite.
1)
How is it possible to allow for say four days of backup files to remain but any older backups to be deleted. At present I only get one file which gets overwritten every day.
2)
What does the Append database option do? I know that it increases the backup file size on every backup. Not sure what that does to the file internally. i.e. why doe the file size increase even if there has not been any activity on the database on that day?
Thanks
View 10 Replies
View Related
Mar 30, 2007
Hi,
I'm trying to setup a Maintenance Plan under SQL2005 to backup selected DB's to a UNC share for later backup to tape. This was easy and straightforward under SQL2k, but doesn't seem to be as simple under 2005 as I've been unable to get it to work.
I have the Maint. Plan created and working to backup to the local drive, but am unable to get it to work to a UNC.
Does anyone have any suggestions?
Regards,
John
View 2 Replies
View Related
Jul 24, 2006
Hello,I am learning SQL Server 2005. I need to know how to make a backup ofa database. I tried (according to my book):BACKUP DATABASE DemoSQLServer TO DISK = "G:DemoSQLServer.bak"But I got error:Incorrect syntax near 'G:DemoSQLServer.bak'.Please help.Thank you very much./RAM/
View 8 Replies
View Related
May 29, 2007
A mainitenance plan is setup to create a daily backup od a database.
It is set to overwrite.
Backup type is set to full.
Not sure why the size of the backup increases every day.
Could this be to do with full/differential backup?
Thanks
View 1 Replies
View Related
Jul 29, 2007
hi-i want to create automatic Backup scheduler for my sql-server 2005 how can i create sql-server2005 backup scheduler
thanks
View 2 Replies
View Related
Jun 4, 2007
Hi,
I created a job to backup my database. Sometimes I get the following error:
The job failed. Unable to determine if the owner (DOMAINAdministrator) of job Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'DOMAINAdministrator'<c/> error code 0x54b. [SQLSTATE 42000] (Error 15404))
I already deleted the job and made it again. Same problem. I don't get that error every day. For example: I got it 4 times last month.
Does anybody know what I can do to resolve the error?
View 1 Replies
View Related
Jan 12, 2006
Is there a way to backup databases within the Sql Server 2005 Manager?
View 1 Replies
View Related
Feb 8, 2007
I know I've been posting a lot about another problem but you all have been most helpful so I thought I'd throw this one at you too.
My nephew's company has a server with Small Business Server 2003 SP1 and they run Windows Backup for their daily backups. They also have SQL 2005 Workgroup on that machine. Prior to SQL 2005, they ran SQL 7 and had no problems with their daily backups. Once they upgraded (clean installed actually) SQL 2005 their backups fail. The event log errors with Event ID 6013 and says:
SQLlib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr=0x80004005 SQLSTATE: 08001, Native Error: 17 Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error Message: [DBNETLIB][ConnectionOpen[Connect[]].]SQL Server does not exist or access denied.
Obviously, SQL Server does exist, so I presume it has to do with an access denial. Microsoft has been no help and Googling other sites have gotten nowhere. DLL updates have been done and hot fixes installed. But the error persists.
Any ideas of where he should look?
Thanks in advance
Dave
View 3 Replies
View Related
Jan 31, 2008
Hi there,
I have sent a mssql backup file in .bak format to my host admin and asked them restore it. but they told me there are 3 files with 3 different dates in that backup what does it mean? should I ask them to restore all of them or just the last one?
Thanks very much in addvance
(context: MS SQL 2005 express)
Cheers
Shahram
View 3 Replies
View Related
Mar 13, 2007
We have a SQL 2005 server running the following backup job:<font face="Courier New" size="2"><br><font color="blue">/* Created by<a href="http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm">freeonline sql formatter</a*/</font><br><br><font color = "blue">EXECUTE</font> <font color ="maroon">master</font><font color = "silver">.</font><font color ="maroon">dbo</font><font color = "silver">.</font><font color ="#8000FF">xp_create_subdir</font><br> <font color = "red">N'\ServerBackupsDBServerName\DB_Name__METABASE'</font><br><br><font color = "blue">GO</font><br><br><font color = "blue">EXECUTE</font> <font color ="maroon">master</font><font color = "silver">.</font><font color ="maroon">dbo</font><font color = "silver">.</font><font color ="#8000FF">xp_create_subdir</font><br> <font color = "red">N'\serverBackupsDBServerName\DB_Name__MSCRM'</font><br><br><font color = "blue">GO</font><br><br><font color = "blue">BACKUP</font> <font color = "blue">DATABASE</font> <font color = "maroon">[db_name__metabase]</font> <font color = "blue">TO</font> <font color ="maroon">disk</font> <font color = "silver">=</font> <fontcolor = "red">N'\serverBackupsDBServerName\DB_Name__METABASE DB_Name__METABASE_backup_200610261158.bak'</font> <font color ="blue">WITH</font> <font color = "maroon">differential</font> <font color = "silver">,</font> <font color ="maroon">noformat</font> <font color = "silver">,</font> <font color = "maroon">noinit</font> <font color ="silver">,</font> <font color = "maroon">name</font> <fontcolor = "silver">=</font> <font color ="red">N'DB_Name__METABASE_backup_20061026115839'</font> <fontcolor = "silver">,</font> <font color = "maroon">skip</font> <font color = "silver">,</font> <font color ="maroon">rewind</font> <font color = "silver">,</font> <fontcolor = "maroon">nounload</font> <font color = "silver">,</font> <font color = "maroon">stats</font> <font color ="silver">=</font> <font color = "black">10</font><br><br><font color = "blue">GO</font><br><br><font color = "blue">DECLARE</font> <font color ="#8000FF">@backupSetId</font> <font color = "blue">AS</font> <font color = "black">INT</font><br><br><font color = "blue">SELECT</font> <font color ="#8000FF">@backupSetId</font> <font color = "silver">=</font> <font color = "maroon">position</font><br><font color = "blue">FROM</font> <font color ="maroon">msdb</font><font color = "silver">.</font><font color ="silver">.</font><font color = "maroon">backupset</font><br><font color = "blue">WHERE</font> <font color ="maroon">database_name</font> <font color = "silver">=</font> <font color = "red">N'DB_Name__METABASE'</font><br> <font color ="blue">AND</font> <font color = "maroon">backup_set_id</font> <font color = "silver">=</font> <font color ="silver">(</font><font color = "blue">SELECT</font> <font color ="fuchsia"><b>MAX</font></b><font color = "silver">(</font><font color= "maroon">backup_set_id</font><font color = "silver">)</font><br> <fontcolor = "blue">FROM</font> <font color ="maroon">msdb</font><font color = "silver">.</font><font color ="silver">.</font><font color = "maroon">backupset</font><br> <fontcolor = "blue">WHERE</font> <font color ="maroon">database_name</font> <font color = "silver">=</font> <font color = "red">N'DB_Name__METABASE'</font><font color= "silver">)</font><br><br><font color = "blue">IF</font> <font color ="#8000FF">@backupSetId</font> <font color = "blue">IS</font> <font color = "blue">NULL</font><br> <font color = "blue">BEGIN</font><br> <font color = "blue">RAISERROR</font> <font color = "silver">(</font><font color ="red">N'Verify failed. Backup information for database ' 'DB_Name__METABASE'' not found.'</font><font color = "silver">,</font><font color = "black">16</font><font color = "silver">,</font><font color = "black">1</font><font color = "silver">)</font><br> <font color = "blue">END</font><br><br><font color = "blue">RESTORE</font> <font color ="maroon">verifyonly</font> <font color = "blue">FROM</font> <font color = "maroon">disk</font> <font color ="silver">=</font> <font color = "red">N'\serverBackupsDBServerName\DB_Name__METABASEDB_Name__METABASE_backup_200610261158.bak'</font> <font color ="blue">WITH</font> <font color = "blue">FILE</font> <fontcolor = "silver">=</font> <font color = "#8000FF">@backupSetId</font> <font color = "silver">,</font> <font color ="maroon">nounload</font> <font color = "silver">,</font> <font color = "maroon">norewind</font><br><br><font color = "blue">GO</font><br><br><font color = "blue">BACKUP</font> <font color = "blue">DATABASE</font> <font color = "maroon">[db_name__mscrm]</font> <fontcolor = "blue">TO</font> <font color = "maroon">disk</font> <font color = "silver">=</font> <font color = "red">N'serverBackupsDBServerName\DB_Name__MSCRMDB_Name__MSCRM_backup_200610261158.bak'</font> <font color ="blue">WITH</font> <font color = "maroon">differential</font> <font color = "silver">,</font> <font color ="maroon">noformat</font> <font color = "silver">,</font> <font color = "maroon">noinit</font> <font color ="silver">,</font> <font color = "maroon">name</font> <fontcolor = "silver">=</font> <font color ="red">N'DB_Name__MSCRM_backup_20061026115839'</font> <font color= "silver">,</font> <font color = "maroon">skip</font> <fontcolor = "silver">,</font> <font color = "maroon">rewind</font> <font color = "silver">,</font> <font color ="maroon">nounload</font> <font color = "silver">,</font> <font color = "maroon">stats</font> <font color ="silver">=</font> <font color = "black">10</font><br><br><font color = "blue">GO</font><br><br><font color = "blue">DECLARE</font> <font color ="#8000FF">@backupSetId</font> <font color = "blue">AS</font> <font color = "black">INT</font><br><br><font color = "blue">SELECT</font> <font color ="#8000FF">@backupSetId</font> <font color = "silver">=</font> <font color = "maroon">position</font><br><font color = "blue">FROM</font> <font color ="maroon">msdb</font><font color = "silver">.</font><font color ="silver">.</font><font color = "maroon">backupset</font><br><font color = "blue">WHERE</font> <font color ="maroon">database_name</font> <font color = "silver">=</font> <font color = "red">N'DB_Name__MSCRM'</font><br> <font color ="blue">AND</font> <font color = "maroon">backup_set_id</font> <font color = "silver">=</font> <font color ="silver">(</font><font color = "blue">SELECT</font> <font color ="fuchsia"><b>MAX</font></b><font color = "silver">(</font><font color= "maroon">backup_set_id</font><font color = "silver">)</font><br> <fontcolor = "blue">FROM</font> <font color ="maroon">msdb</font><font color = "silver">.</font><font color ="silver">.</font><font color = "maroon">backupset</font><br> <fontcolor = "blue">WHERE</font> <font color ="maroon">database_name</font> <font color = "silver">=</font> <font color = "red">N'DB_Name__MSCRM'</font><font color ="silver">)</font><br><br><font color = "blue">IF</font> <font color ="#8000FF">@backupSetId</font> <font color = "blue">IS</font> <font color = "blue">NULL</font><br> <font color = "blue">BEGIN</font><br> <font color = "blue">RAISERROR</font> <font color = "silver">(</font><font color ="red">N'Verify failed. Backup information for database ' 'DB_Name__MSCRM'' not found.'</font><font color = "silver">,</font><font color = "black">16</font><font color = "silver">,</font><font color = "black">1</font><font color = "silver">)</font><br> <font color = "blue">END</font><br><br><font color = "blue">RESTORE</font> <font color ="maroon">verifyonly</font> <font color = "blue">FROM</font> <font color = "maroon">disk</font> <font color ="silver">=</font> <font color = "red">N'\serverBackupsDBServerName\DB_Name__MSCRMDB_Name__MSCRM_backu p_200610261158.bak'</font> <font color = "blue">WITH</font> <font color ="blue">FILE</font> <font color = "silver">=</font> <fontcolor = "#8000FF">@backupSetId</font> <font color = "silver">,</font> <font color = "maroon">nounload</font> <font color ="silver">,</font> <font color = "maroon">norewind</font></font>This job was set up long before i started here and the problem is thatthe backup file itself has grown to be over 230 GB. It does notappear that the backup job is pruning the file. is there a way toview the contents of this file and then prune it so we keep no morethen two weeks worth of data.Thanks
View 1 Replies
View Related
Feb 5, 2006
How
to backup asymmetric key in SQL 2005 created in the following way so it
can be copied to another server ? Also can you copy it to the other
server after backing it up.
CREATE ASYMMETRIC KEY ccnumber WITH ALGORITHM = RSA_512
ENCRYPTION BY PASSWORD = 'password';
View 11 Replies
View Related
Mar 15, 2007
I have ctreated a maintenance plan to backup a database daily.
The option is set to overwrite.
1)
How is it possible to allow for say four days of backup files to remain but any older backups to be deleted. At present I only get one file which gets overwritten every day.
2)
What does the Append database option do? I know that it increases the backup file size on every backup. Not sure what that does to the file internally. i.e. why doe the file size increase even if there has not been any activity on the database on that day?
Thanks
View 6 Replies
View Related
Sep 13, 2007
Problems with Database Backup.
Want to backup the transactoin log, but I have the failure:
The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. [SQLSTATE 42000] (Error 4208) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
I set the recovery model to FULL, that worked fine for about six hours. After same failure again. And the recovry model was SIMPLE.
Found this in the Eventlog:
Setting database option RECOVERY to SIMPLE for database
So what can I do? Thanks for your ansers!
Greetz
View 13 Replies
View Related
Oct 2, 2006
I am new to sql server 2005.I am trying to set up databse backup using databse management.but some how it is not working and i am getting error after all settings done.
Can any one have experience on this. plz i am in desperate trouble.
I am thanksful to you in advance.
Thanks,
Bharat.
View 10 Replies
View Related
Jul 11, 2007
Description:
Created a maintenance plan to backup the database.
Scheduled the job to run the maintenance plan.
Backup ran.
No errors.
Restored the database to a new database with different name.
Problem:
One column in one table is not correct.
The column is a smallint. The value for this column in the original database was 1.
The value in the restored database was zero.
Out of 7 database backups, 2 of the backups have this problem, the other 5 backups
restore the column correctly.
View 6 Replies
View Related
Oct 26, 2007
I am very new to SQL 2005. I need to automate backup for the SQL server which can take backup of all databases from the server at fixed time without using third party backup system. Thank you for help.
View 13 Replies
View Related
Oct 4, 2007
Hi All
I have recently installed the sql server 2005 on my server. I am going to setting up the maintenance plan to backing up my DB on the network.
I can do it locally but i want to backup directly into the shered folder on the network.
Please help me
View 2 Replies
View Related
Aug 3, 2007
I use SQL 2005 Database in my ASP.Net 2.0 site, I have to require admin backup db for me every time, I hope to I can backup by myself , how can I do?
You know Microsoft SQL Server Database Publishing Wizard can restore DB easily!
Many thanks!
View 6 Replies
View Related
Oct 5, 2007
I have a community server running in a hiring host, and I also install it on localhost. I would like to know how to backup the database from hosting and restore it to the site running on my localhost so that two sites is the same and in case there is an error from the hosting I can recover my database.
I can connect to my hosting database easily using SQL server Studio 2005, but the hosting does not offer backup through control panel. Could you please instruct me how to backup and restore database by SQL Server Management Studio.
Thank you very much,
View 2 Replies
View Related
Dec 10, 2007
Hi,Good morning to All,
I have SQL Server 2005 installed on my system. Recently I have formatted by computer. But I couldn't take backup of my data. Big loss.
For this, I've googled also. but I couldn't get clear information.
I want like the following:I could able to backup entire the Database either into my pen-drive, or some other media.And, latter I could able to put the Data back into my system.
Can anyone please tell how to take backup of my Data, and Restore also.
Thanks in advance,Ashok kumar.
View 1 Replies
View Related
Jun 2, 2008
i'm trying to set up one of the asp.net website starter kits and part of the process is to backup the sql express db and then import it into the sql 2005 at the web hosting account. it's not working and i'm wondering if there's any difference between the backups they make. the sql express makes a file with a .bak extension and the sql 2005 at the host makes a file with a .sqlbak extension. i was assuming that was just a naming thing and not a structural thing but the host's tech support has said:
"This sort of thing happens when the database being imported is not properly formatted. You can try downloading and using sql express from microsoft to see if you can do it manually, but most likely you will need to save your database again properly set for import to an mssql server rather than however you did."
all i had done was rename the .bak file from express to .sqlbak as that was the choice for backup files.
i will note that it also failed importing the .mdf, which works fine locally with the site but i did make some changes to it from the original that came with the starter kit.
should a backup file made with sql express (using sql management studio express, by right clicking on the file and choosing tasks > backup) normally be importable by sql 2005?
or, i suppose, does it make sense that a db that works fine locally with sql express (within a visual web developer express project anyway) would actually be "formatted" in a way that would cause it to fail to import into sql 2005?
thanks much for any assistance.
View 3 Replies
View Related
Feb 18, 2006
hello all
i have Database of having 5 tables , 5 SP, etc
now due to some reason i have to format my Harddisk.
so which files i shuold take as Backup so next time i install Sqlserver 2005 so i will have to run(paste ) only those backuped files and i will have my database ready , pls show me path for taking back up.
thank u
View 3 Replies
View Related
Jun 26, 2007
Hello Friends:
My problem relates to backing up my MS SQL 2005 database which is sitting on a shared server at a hosting company.
OVERVIEW:
- Hosting company is using MS SQL 2005
- I am using the SQL Server Management Studio that comes with SQL Server 2005 Standard (NOT Express), which is installed on MY PC.
- So, I am connecting to the SQL server over the internet
WHAT I WANT TO ACHIEVE:
- I would like to backup the data sitting on the Hosting company's MS SQL Server. I only have one database on this SQL Server. There are of course 100s of other databases on the same server which belong to other customers of the hosting company.
- I want to bring the backup to MY PC, from the SQL Server.
- As far as I can tell the following options within SQL Server Management Studio may be of help to me. I do not know which one I should use or which one is best or what is the proper method. 1) Select Backup option from the Tasks menu (but it only shows me drives/devices on the Hosting SQL Server, not my PC, so I can’t backup to my PC) 2) Export Data (it does not work, showing errors ‘…not a trusted connection…’ I have no clue what a trusted connection is. 3) Copy Database (which is supposed to copy the remote database on the Hosting company SQL server, to my local SQL Server running on my PC). I go through the wizard, on the last screen it just hangs i.e. shows- not responding)
MY QUESTION TO THE COMMUNITY:
How do I backup the database sitting on the hosting company SQL server? I of course need to bring the backup to my PC.
View 5 Replies
View Related
Jul 9, 2007
Hi there
I feel like a complete nitwit. I've been using SQL 2000 for about 5 years now and regularly set up automatic backups using the wizard for many people. I'm in no way an advanced user and have enjoyed some of the more user-friendly features of SQL 2000 such as the backup wizard.
Well now we have SQL 2005 and I can't find the "wizard". I did a lot of googling and found very little on this. The frustration is mounting - let alone the fact that I had to edit the registry just to be able to perform a manual backup in the first place... :-(
Apparently their is a "maintenance plans" folder but the only place I can find this is under "Legacy" and you can't create jobs there.
Has anybody else had this issue? Is there a bug in SQL 2005? I reinstalled the full version with all options selected and still can't find this folder. Am I just being completely "blonde"?
View 4 Replies
View Related
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
Apr 3, 2008
Hello All,
I tried to backup my database in SQL Server 2005 (Express edition).
But the size of the backup file was the same as that of the database file.
Is there any means to compress and backup so that the size of the backup file is much smaller?
Regards,
Yuvanya
View 1 Replies
View Related
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
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