|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
restoring db without logOur database hardware crashed. We had to rebuild that from scratch. After rebuilding, there was no user databases. Now, I was restoring databases from backup. I have a big data file (about 5.6 GB). When I use the restore command as follows, I see it tries to add the log files in the D:\MSSQL\Data folder. That log file becomes more than 17 GB. It runs for more than an hour and still I do not see the database is on line. Then I cancel the query. I have done it several times today. restore database TestDB from disk='\\dr1\DBback\TestDB.dat' with move 'TestDB_dat' to 'D:\MSSQL\Data\TestDB.mdf', move 'TestDB_log' to 'D:\MSSQL\Data\TestDB.ldf' Then I deleted the mdf and ldf files in the data folder and tried without the log portion. restore database TestDB from disk='\\dr1\DBback\TestDB.dat' with move 'TestDB_dat' to 'D:\MSSQL\Data\TestDB.mdf' still I see it is placing the ldf file and the size is 17 GB, and runs for more than an hour and the database was not restored. Also, I have no way of knowing why the hardware failed. It is a brand new Dell server. Could anyone please tell me how I can solve this? This is a very important database and needs to be online today. I thank you million times in advance for you help. Best regards, mamun The transaction log need to be created when you restore. Let it run. Make sure you refresh in EM, or
try to connect to the database using QA. > Also, I have no way of knowing why the hardware failed. It is a brand You should check eventlog etc for error messages.> new Dell server. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "microsoft.public.dotnet.languages.vb" <mamun***@hotmail.com> wrote in message news:1120068371.189171.44820@f14g2000cwb.googlegroups.com... > Hi All, > > Our database hardware crashed. We had to rebuild that from scratch. > After rebuilding, there was no user databases. > > Now, I was restoring databases from backup. > > I have a big data file (about 5.6 GB). > > When I use the restore command as follows, I see it tries to add the > log files in the D:\MSSQL\Data folder. That log file becomes more than > 17 GB. It runs for more than an hour and still I do not see the > database is on line. Then I cancel the query. I have done it several > times today. > > restore database TestDB > > from disk='\\dr1\DBback\TestDB.dat' > > with move 'TestDB_dat' to 'D:\MSSQL\Data\TestDB.mdf', > move 'TestDB_log' to 'D:\MSSQL\Data\TestDB.ldf' > > > Then I deleted the mdf and ldf files in the data folder and tried > without the log portion. > restore database TestDB > > from disk='\\dr1\DBback\TestDB.dat' > > with move 'TestDB_dat' to 'D:\MSSQL\Data\TestDB.mdf' > > still I see it is placing the ldf file and the size is 17 GB, and runs > for more than an hour and the database was not restored. > > Also, I have no way of knowing why the hardware failed. It is a brand > new Dell server. > > Could anyone please tell me how I can solve this? This is a very > important database and needs to be online today. > > I thank you million times in advance for you help. > > Best regards, > > mamun > I don't think you can restore a database without transaction log. Looks like
your backup has a huge transaction log. The SQL server should restore the entire database and rollback/forward the trasactions. I will take sometime to restore. 1. Do you see the database in the EM with "(Loading)" status? 2. Are you trying to restore the database from network share?. If so try to copy the backup locally and then restore. -- Show quoteThanks Ravi "microsoft.public.dotnet.languages.vb" wrote: > Hi All, > > Our database hardware crashed. We had to rebuild that from scratch. > After rebuilding, there was no user databases. > > Now, I was restoring databases from backup. > > I have a big data file (about 5.6 GB). > > When I use the restore command as follows, I see it tries to add the > log files in the D:\MSSQL\Data folder. That log file becomes more than > 17 GB. It runs for more than an hour and still I do not see the > database is on line. Then I cancel the query. I have done it several > times today. > > restore database TestDB > > from disk='\\dr1\DBback\TestDB.dat' > > with move 'TestDB_dat' to 'D:\MSSQL\Data\TestDB.mdf', > move 'TestDB_log' to 'D:\MSSQL\Data\TestDB.ldf' > > > Then I deleted the mdf and ldf files in the data folder and tried > without the log portion. > restore database TestDB > > from disk='\\dr1\DBback\TestDB.dat' > > with move 'TestDB_dat' to 'D:\MSSQL\Data\TestDB.mdf' > > still I see it is placing the ldf file and the size is 17 GB, and runs > for more than an hour and the database was not restored. > > Also, I have no way of knowing why the hardware failed. It is a brand > new Dell server. > > Could anyone please tell me how I can solve this? This is a very > important database and needs to be online today. > > I thank you million times in advance for you help. > > Best regards, > > mamun > > Hi Ravi and Tibor,
I have tried copying the backup file from the network share to the datbase server. When I run the restore command, I get the following error. Server: Msg 3270, Level 16, State 1, Line 1 An internal consistency error occurred. Contact Technical Support for assistance. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Could you please help what I need to do. I am really in need of help. Thanks a million. Best regards, mamun *** Sent via Developersdex http://www.developersdex.com *** Some Questions
1. What is operating system server running SQl Server ? 2. What is the file system type (NTFS, FAT etc.,) of the server running SQl Server 3. What is the file system type of NETWORK Share? -- Show quoteThanks Ravi "Mamun Ahmed" wrote: > Hi Ravi and Tibor, > > I have tried copying the backup file from the network share to the > datbase server. When I run the restore command, I get the following > error. > > > Server: Msg 3270, Level 16, State 1, Line 1 > An internal consistency error occurred. Contact Technical Support for > assistance. > Server: Msg 3013, Level 16, State 1, Line 1 > RESTORE DATABASE is terminating abnormally. > > > Could you please help what I need to do. > > I am really in need of help. > > Thanks a million. > > Best regards, > > mamun > > > > *** Sent via Developersdex http://www.developersdex.com *** > Also try RESTORE VERIFYONLY command
-- Show quoteThanks Ravi "Mamun Ahmed" wrote: > Hi Ravi and Tibor, > > I have tried copying the backup file from the network share to the > datbase server. When I run the restore command, I get the following > error. > > > Server: Msg 3270, Level 16, State 1, Line 1 > An internal consistency error occurred. Contact Technical Support for > assistance. > Server: Msg 3013, Level 16, State 1, Line 1 > RESTORE DATABASE is terminating abnormally. > > > Could you please help what I need to do. > > I am really in need of help. > > Thanks a million. > > Best regards, > > mamun > > > > *** Sent via Developersdex http://www.developersdex.com *** > Hi mamun,
Go ahead and contact Microsoft PSS if the data is very critical. Have a look into the below link on MS PSS. "Good Luck" http://support.microsoft.com/common/international.aspx?rdpath=1&gprid=2852 Thanks Hari Show quote "Mamun Ahmed" <mamun***@hotmail.com> wrote in message news:%23YeNygOfFHA.3940@tk2msftngp13.phx.gbl... > Hi Ravi and Tibor, > > I have tried copying the backup file from the network share to the > datbase server. When I run the restore command, I get the following > error. > > > Server: Msg 3270, Level 16, State 1, Line 1 > An internal consistency error occurred. Contact Technical Support for > assistance. > Server: Msg 3013, Level 16, State 1, Line 1 > RESTORE DATABASE is terminating abnormally. > > > Could you please help what I need to do. > > I am really in need of help. > > Thanks a million. > > Best regards, > > mamun > > > > *** Sent via Developersdex http://www.developersdex.com *** "microsoft.public.dotnet.languages.vb" schrieb:
Show quote > Hi All, 1. The TA-log is part of a full database backup and will always be restored > Our database hardware crashed. We had to rebuild that from scratch. > After rebuilding, there was no user databases. > Now, I was restoring databases from backup. > I have a big data file (about 5.6 GB). > When I use the restore command as follows, I see it tries to add the > log files in the D:\MSSQL\Data folder. That log file becomes more than > 17 GB. It runs for more than an hour and still I do not see the > database is on line. Then I cancel the query. I have done it several > times today. > > restore database TestDB > from disk='\\dr1\DBback\TestDB.dat' > with move 'TestDB_dat' to 'D:\MSSQL\Data\TestDB.mdf', > move 'TestDB_log' to 'D:\MSSQL\Data\TestDB.ldf' > > Then I deleted the mdf and ldf files in the data folder and tried > without the log portion. > restore database TestDB > from disk='\\dr1\DBback\TestDB.dat' > with move 'TestDB_dat' to 'D:\MSSQL\Data\TestDB.mdf' > > still I see it is placing the ldf file and the size is 17 GB, and runs > for more than an hour and the database was not restored. > > Also, I have no way of knowing why the hardware failed. It is a brand > new Dell server. > Could anyone please tell me how I can solve this? This is a very > important database and needs to be online today. > I thank you million times in advance for you help. > Best regards, > mamun with the database. 2. If your restore statement really looks like that then the most important element is missing: with recovery. Without that you can wait for your db until hell is freezing ...  |
|||||||||||||||||||||||
Other interesting topics