Restoring Without Dumps
Aug 13, 1998Hi !
I have one crashed database !
I have no dumps at all !
I have cold backup of the data files !!
Is it possible to just restore the datafiles and everything`s nice again ??
ADVERTISEMENT
STACK DUMPS AND SYMPTOM DUMPS
Apr 26, 1999Can anyone tell me where I can find information about why sql server might be executing a stack and/or symptom dump?
That is, what are some of the conditions that might cause this. Every time I try to DBCC DBREINDEX on a certain table, stack
and symptom dumps occur and SQL Server remains incommunicado (can't connect, even locally) until I restart it. I'm going to try to fix the table by using
rename table, create new table (and dependent objects) , transfer data, and toast the original table. No problem, I've done that
before with smashing success. But, if this solves my problem, I'll still be no wiser about what it was that caused the problem in
the first place. Any suggestions, questions, comments, or even jeers would be appreciated.
Thanks,
Chris
Need Of SQL Dumps
Feb 13, 2008HiIam new to this groupSO can any one provide me with dumps of 1z0-007regdsAJax
View 4 Replies View RelatedTransaction Log Dumps
Oct 6, 1999Hi,
I need to set up a dump of my main database's transaction log to dump every hour but not overwrite until the 8th hour (keeping 7 log dumps). Can anyone tell me how to set up the scheduled tasks for the transaction log dump? Is there anything special I need to do for the main database dump?
Thank you, Laurie
Problems Doing Dumps
Jan 25, 1999Hi:
Actually we have problems doing database dumps, so we're copying directly the .DAT files
to a backup machine, I mean the .DAT files are the data devices that uses SQL no dumps files.
We can do or eecute the dump process.
What problems can we expect doing this?
Which can be the problems 'cause we cannot dump our DB's?
Thanks
Question Regarding Dumps
Jun 1, 1999I have noticed a question on the Admin exam which involves declaring and usting a time variable for scheduling a backup or dump of a database. Is this possible and has anyone else seen this on the exam or used it in reality?
View 2 Replies View RelatedPlease Help Me Debug Hex Dumps
Jul 9, 2007Hello gurus,
Our SQL Servers is giving us a headache, after a certain period in time, either SQL Service automatically shuts down by itself or hangs. I've opened the logs and found hex dumps. Can you help me out with these?
2007-07-08 04:04:35.20 spid53 SqlDumpExceptionHandler: Process 1760 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* ************************************************** *****************************
*
* BEGIN STACK DUMP:
* 07/08/07 04:04:35 spid 53
*
* Exception Address = 0042D46D
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 6AF1EDF0
* Input Buffer 4088 bytes -
* USE Document DBCC DBREINDEX (dtproperties) DBCC DBREINDEX (REfID_DocID
* ) DBCC DBREINDEX (RF_UNISYS_ErrorCodes) DBCC DBREINDEX (SYS_Document_F
* lat_Meta_Data) DBCC DBREINDEX (SYS_Document_Meta_Data) DBCC DBREINDEX
* (SYS_Document_Meta_Detail) DBCC DBREINDEX (SYS_Documents) DBCC DBREIND
* EX (SYS_ETFuelType) DBCC DBREINDEX (SYS_ETStatus) DBCC DBREINDEX (SYS_
* HF_Document_Meta_Data) DBCC DBREINDEX (SYS_HF_MI_Emission_Results) DBC
* C DBREINDEX (SYS_ITP_Failed) DBCC DBREINDEX (SYS_MI_Emission_Results)
* DBCC DBREINDEX (SYS_RF_Document_Meta_Data) DBCC DBREINDEX (SYS_RF_Docum
* ent_Status) DBCC DBREINDEX (SYS_TR_Document) DBCC DBREINDEX (SYS_TR_SM
* S_Document) USE Industry DBCC DBREINDEX (dtproperties) DBCC DBREIND
* EX (IND_MF_Industry) DBCC DBREINDEX (RF_ErrorCodes) DBCC DBREINDEX (RF
* _OperationCodes) DBCC DBREINDEX (RF_Unisys_ErrCodes) DBCC DBREINDEX (S
* YS_Admin_Has_Agents) DBCC DBREINDEX (SYS_Admin_Sharing) DBCC DBREINDEX
* (SYS_Companies) DBCC DBREINDEX (SYS_Company_Has_Admins) DBCC DBREINDE
* X (SYS_Company_Meta_Data) DBCC DBREINDEX (SYS_HF_Admin_Has_Agents) DBC
* C DBREINDEX (SYS_HF_Companies) DBCC DBREINDEX (SYS_HF_Company_Has_Admin
* s) DBCC DBREINDEX (SYS_HF_Company_Meta_Data) DBCC DBREINDEX (SYS_HF_Us
* er_Meta_Data) DBCC DBREINDEX (SYS_HF_Users) DBCC DBREINDEX (SYS_MF_App
* Variables) DBCC DBREINDEX (SYS_MI_Token) DBCC DBREINDEX (SYS_Page_Acce
* ss) DBCC DBREINDEX (SYS_Pages) DBCC DBREINDEX (SYS_Password_History)
* DBCC DBREINDEX (SYS_RF_Announcement) DBCC DBREINDEX (SYS_RF_BodyType)
* DBCC DBREINDEX (SYS_RF_Color) DBCC DBREINDEX (SYS_RF_Company_Meta_Data)
* DBCC DBREINDEX (SYS_RF_Company_Status) DBCC DBREINDEX (SYS_RF_DieselT
* ype) DBCC DBREINDEX (SYS_RF_EmissionFees) DBCC DBREINDEX (SYS_RF_Emiss
* ionRules) DBCC DBREINDEX (SYS_RF_Fuel_Type) DBCC DBREINDEX (SYS_RF_Hel
* pDetails) DBCC DBREINDEX (Sys_RF_Make) DBCC DBREINDEX (SYS_RF_Month)
* DBCC DBREINDEX (SYS_RF_MVClassification) DBCC DBREINDEX (SYS_RF_MVType)
* DBCC DBREINDEX (SYS_RF_MVType2) DBCC DBREINDEX (SYS_RF_Page_Groups)
* DBCC DBREINDEX (SYS_RF_Purpo
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* Invalid Address 77F80000 77FFBFFF 0007c000
... <snipped>
* xpstar 09240000 09248FFF 00009000
* rsabase 092D0000 092F2FFF 00023000
* dbghelp 0AA80000 0AB7FFFF 00100000
*
* Edi: 0AA53937: 00000000 00000000 00000000 84004A00 98018901 C501B101
* Esi: 6AF1EDF0:
* Eax: 00000878:
* Ebx: FFFFE000:
* Ecx: 3FFFF800:
* Edx: FFFFE000:
* Eip: 0042D46D: CA8BA5F3 F303E183 DC7D8BA4 83D045FF 4D8B2CC7 E9D233E0
* Ebp: 0A1BFCC0: 0A1BFCE4 0042D5CD 71E428CC 71E40570 71E40988 0AA519A0
* SegCs: 0000001B:
* EFlags: 00010206: 00530053 0052004F 003D0053 00000034 0053004F 0057003D
* Esp: 0A1BFC28: 0AA519A0 71E4052C 00000000 00000010 71E408A0 00000010
* SegSs: 00000023:
* ************************************************** *****************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 0042D46D Module(sqlservr+0002D46D)
* 0042D5CD Module(sqlservr+0002D5CD)
* 0042D6C7 Module(sqlservr+0002D6C7)
* 00508750 Module(sqlservr+00108750)
* 0051EB18 Module(sqlservr+0011EB18)
* 0051E9E4 Module(sqlservr+0011E9E4)
* 0085EACA Module(sqlservr+0045EACA) (GetIMallocForMsxml+0006A08A)
* 004229A7 Module(sqlservr+000229A7)
* 0087B87B Module(sqlservr+0047B87B) (GetIMallocForMsxml+00086E3B)
* 0087E3C9 Module(sqlservr+0047E3C9) (GetIMallocForMsxml+00089989)
* 0059A449 Module(sqlservr+0019A449)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 7C57B3BC Module(KERNEL32+0000B3BC) (lstrcmpiW+000000B7)
* -------------------------------------------------------------------------------
*Dump thread - spid = 53, PSS = 0x55a35280, EC = 0x55a355b0
*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0020.txt
*** Problems occur intermittently, sometimes after our full backup which occurs every 0000h, sometimes 30 minutes after our transaction log dumps.
Please advice me on my next step. Thanks
SQL 2K Dumps Via Network
Mar 18, 2004Hi all,
I've read that the SQL dump can only be done directly into the local server. Is there a way to put directly the dump into another server via the network (not copying it but writing it during the process of backup).
Any help much apreciate.
Thanks
High CPU During Tran Log Dumps
Oct 22, 2002We are experiencng high cpu utilization across all 4 cpu's at the top of the hour when our transaction log dump job runs. Has anyone observed this bahavior before? Is there anything we can do to mitigate this? Thank You.
View 4 Replies View RelatedAutomating Transaction Log Dumps
May 5, 1999I am testing a procedure to automate the transaction log dump. I am following the steps located in Chapter 22 of the Microsoft SQL Server Administrator's Companion ("Automatic Transaction Log Dumps Using Performance Monitor"). The alert in Performance Monitor appears to be starting when the log is 75% full, but the alert is not firing off the file that contains the dump transaction sql command. For the 'Run Program on Alert' box this is what I have: isql -Ssvrname -Usa -P -id:appsmssqlinndump.sql
The dump.sql file contains: 'dump transaction pubs with no_log'
I have also tried the following 4 steps: 1) Created a SQL Alert Messsage, 2) Created an NT Performance Monitor Threshold Alert to run sqlalrtr to issue a certain error when the pubs log is 75% full, 3) Created a TSQL Task, and 4) Created a SQL Server Alert to run the Task created in step 3. This appears to do the same thing. The Alert is fired off, but the Task is never executed. Note: I am able to execute the task from within the Schedule Tasks Window.
I am using Standard Security with SQL Server 6.5 (sp5a) running on NT4.
Thanks for you help in advance.
Exam 70-229 Preapration Dumps
May 6, 2007Hi Forum,
I am new to microsoft SQL server as I am from Oracle background. I am preparing to the MCP certification for Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. The exam shows as SQL server 2000 is there any exam for SQL server 2005.
Is it the write exam to give to start as fesher into microsoft platform. Iam into development not towards administration.
If any body has any Exam preparation questions please forward them to krishna.kanigelpula@gmail.com.
Regards,
Krishna.
Cross Server Database Dumps
Oct 5, 2004I am attempting to remember the string to dump/restore a database to a different physical server.
I have the database on Server 1 and want to back it up to server 2. Can anyone refresh my memory?
Thanks
Check To Make Sure Dumps Are Not Corrupt
Sep 30, 1998How can I check to make sure that my dumps are not corrupted? I have been using a utility from Microsoft called DSCAN5, but have found that this has some limitations.
View 1 Replies View RelatedAutomate Load Of Transaction Dumps
Jul 1, 1999Hi,
does anybody know how to automate the loading of incremental transaction dumps. The manual way is to use the "load tran DB with FILE = x" statement.
Since this has to be done in the right sequence and i need to automate this task to keep a second server up to date i like to know if there is a stored procedure
or any other tool which could do the task.
Thanks for your help
Best Regards
Yorn Ziesche
SSIS - OLE DB - IBM DB2 - SQLDUMP - More Dumps Than Works....
Feb 8, 2007I have a package which access a DB2 database and pulls data from a single table. I can't put a specific event on it, but the package has been causing a dump to occur on a rather regular basis. The really odd part is sometime when I add a data viewer on the output link of the OLE DB Source it works....then it starts to dump again a couple of executions later. There are not date/time values involved in the result set, just character strings. Default code page is set to 1252 and use default page is set to False....any ideas appreciated - this is really starting to drive me nuts!
Thanks
Can I Read Transaction Dumps (*.TRN) File In SQL Server 7.0
Jul 28, 2000our users believe that we lost some valid data, but no one knows who did it,
I thought I can find it from the transaction dumps I take every hour
so ,Can I read Transaction Dumps (*.TRN) file in SQL server 7.0 or Can I get this information through other means.
Thanks for your help
DP
Backing Up: Dumps Vs SQL Backup Agents Using BackupExec
May 31, 2000I'm going back and forth on an issue and was looking for some outside observations. I have over a dozen SQL NT servers, both 6.5 and 7.0. On some servers I'm dumping the databases and backing up the dumps with Veritas BackupExec, on 4 (two SQL 6.5, two v7) I'm backing up with the Veritas SQL Backup Agent.
Obviously, if you don't have room to dump a database, you must use the backup agent. That is the case on one of my servers and becoming so on a second. But my personal preference is to do the dump/backup.
(as a side note, one server is not backing up correctly with the backup agent but ultimately that box will require it due to DB growth, so it is something that I have to resolve)
I like the dump system for a few reasons. I find it easier to load from a dump, particularly a single table. Likewise, I find it easier to copy a database by loading from a dump rather than going from a backup, but that's mainly because of BackupExec being a little bit strange on redirecting restores.
Here's my clincher. I find restores via the backup agent to be ridiculously slow. Let's say I have a 5gig DB that has 1.5gig in it. The dump size will probably be somewhere below 2gig. The restore via backup agent carefully writes the entire 5gig even though 3.5g of that is empty. This takes a lot of time. Add to that the "post-restore DBCC". I had such a restore take something on the order of 13 HOURS which, needless to say, conflicted with my nightly DBCC's and backups.
OK. End of rant. Any suggestions or thoughts on the subject?
Restoring Database Leaves Me With (Restoring...) Message
Jan 9, 2007I did a full backup of a db from one server(Express2005) and trying to restore it to a different instance of SQL2005 on the same development machine. (Also had some fulltext columns if that means anything)
Many failures but finally got it to report all was successful except the icon in Object Explorer shows (Restoring...) with no indication of any real activity going on. It's a tiny database with hardly any data in it.
Just not sure what the heck is going on there. It also won't let me into the database until this the (Restoring...) goes away.
Any advice on how to get this thing finished out?
Restoring DB
Oct 18, 2000Hi, I am restoring a database as a complete step. The database icon, under the Sql server Group in the Sql server enterprise manager, turned into gray and got a word (loading) infront of the database name, what does that means?
Ali
Restoring A DB
Nov 1, 1999I am just curious to know whether it's possible to restore a SQL 6.5 DB from a DB device file. For e.g. i have a device file abc.dat which contains a db. Now thru this device file can i restore the data on xyz database.
View 3 Replies View RelatedRestoring
Jun 2, 2003Hi All,
I'm trying to restore a database to a completely new database from an exsiting full backup.
On the backup device there are two full backups from different dates.
How can I specify which one of the two backups I want use for my restore (The only difference is the date ??
Thanks,
Restoring A DB
Feb 27, 2002I had SQL win2k running on a machine and had 2 dbs. unfortunately the hard drive failed (ntldr crashed). i was able to copy the contents of from the old drive (so i have the DB files) but no backups.
Is there any way to import this data into a new DB?
Restoring
Aug 18, 2005Can you restore a backup (bak) file to a different server? E.g. client gets server nicked, they have bak files, can I run a restore to my sql server?
I can see the with MOVE option, but I can't see how to attach (to the new server) if the database wasn't detached (from the nicked server).
Restoring Db
Sep 24, 2007i am getting the following error when i try and restore a datbase
The log in this backup set begins at LSN 110000000011300001, which is too late to apply to the database. An earlier log backup that includes LSN 102000000188100001 can be restored..
Restoring
Feb 4, 2008while iam restoring my back up i got this error message
Msg 3117, Level 16, State 1, Procedure res, Line 26
The log or differential backup cannot be restored because no files are ready to rollforward.
Msg 3013, Level 16, State 1, Procedure res, Line 26
RESTORE DATABASE is terminating abnormally.
Restoring A DB
Jul 23, 2005Hey all.Can anyone point me in the general direction of documentation whichwould tell me how to restore a DB via the command line instead of usingenterprise manager?ThanksMatt
View 2 Replies View RelatedRestoring DB
Jul 20, 2005Hi all,I have a very old MSSQL data backup file.I do not even remember that it was created in SQL7 or 2000.Anyway, I'm trying to recreate DB from this backup.Is it possible to create DB from backup file?I tried restore from that file and SQL server complaining."The file on device '***' is not valid Microsoft tape format backup set."Thanks-Jay
View 2 Replies View RelatedRestoring From .MDF/.LDF
Jan 15, 2007Hi there,
I've got a .mdf/.ldf database/log. I'm trying to bring it into SQL Server Management studio, but can't figure out how. I've gotten as far as "Attaching" it, but can't figure out where to go from there. Can anyone help me out. I know this is very basic.
Thanks.
Restoring DB
Jun 1, 2006Hi,
I have created a DB on my local machine.
Now I would like to copy this on to another machine.
I stopped the service and then copied both the MDF file and the
log files into the same folder as in Data folder of the second machine.
When I run theStudio express I cannot find the MDF file.It does not show up in the
the DB folder or window.
When I try to create one it says that the DB exists.
What am I missing?
I tried doing a backup and restore but then the DB is not created on the second machine and
hence wont work.
Tnx
Restoring From .bak
May 11, 2007i have sql server 2005 dev installed on a laptop. i have 2 .bak's from production sql server 2005 database. i went through the gui restore procedure and both backup files completed successfully. now both databases are in the (Restoring...) status and have been for quite some time. i have sp2 applied. when will these become available? each .bak was around 400 mb. it has been a few hours.
View 8 Replies View RelatedRestoring Problem
Oct 24, 2007When i try to restore my back up i got this error: Solution?
View 2 Replies View RelatedRestoring A Db From A .bak File?
Apr 10, 2006Hi,I'm new to sql but have a website running it on a hosted site. I want to have a local copy of the site running here for testing. I have everything set on my local machine to run it including MSDE and Enterprise Mgr.I've created a blank db with the same name,username and password on my local machine. From my host I received a dbname.bak file which they said I should just restore to my local machine. This sounded simple but I have no idea how to do this. When I right click on the db file within Ent.Mgr I see the Restore option but I can figure out how to designate the dbname.bak file as the source. I also see an option to import but that isn't any better.Does anyone have some simple directions which will show me the proper steps and where I should be to do this? I'd really appreciate it. I assume it's simple but not having ever done it it has me stumped.Thanks!
View 11 Replies View RelatedRestoring DB From The Network
Apr 4, 2001Hi,
I am trying to restore SQL7 DB from the Network M/C,here is the Procedure i am following
i have backup file on ABCsqlbackup where ABC is M/c Name on the network
from my Server i mapped ABCsqlbackup to the I drive
then from enterprise magager i tried to restore DB and i gave path as I:xyz.bak
for backup device location where xyz.bak is backup file name.
when i tried to restore like this it is giving error "unable to verify backup file location"
and i checked in SQL server logs i found that message like..
"Unable to open Backup Device I:xyz.bak Failed to open.Operating system error,Unknown user name or bad password"
and that Sqlbackup directory is shared and it has full access to everyone.
Can anybody tell me how to restore from the Network, and where i am doing wrong.
Thanks in Advance
Mark