Viewing 15 posts - 43,201 through 43,215 (of 49,566 total)
Anu (11/12/2008)
there is ... there have to be..
Yes. Restore a backup.
If you don't have a backup you don't get your data back. That's the point of a backup. SQL...
November 12, 2008 at 6:32 am
krayknot (11/12/2008)
he wants to hide the table and he can hide the xml.
Where? In another table? In the file system? Some other place?
November 12, 2008 at 1:27 am
Backup restore isn't a good option here. Two things you can consider.
Database mirroring with a database snapshot on the mirror. The snapshot is readonly and is an image of the...
November 12, 2008 at 1:24 am
kokila (11/12/2008)
Is there any other way so that we can only analyze and find out the problem.
You can download a debugger (http://www.microsoft.com/whdc/devtools/debugging/default.mspx), point it's symbols path at MS's public symbols...
November 12, 2008 at 1:11 am
Anu (11/12/2008)
any way sql server have the facility to get back the older state like restore . if any tiger know that plzz enclose the information.
Yup! Restore a backup that...
November 12, 2008 at 12:50 am
Just be careful with SP3. What's available right now is RC0 - a release candidate. It's still in testing and there may still be bugs. It should not be applied...
November 12, 2008 at 12:46 am
rbarryyoung (11/11/2008)
November 12, 2008 at 12:37 am
That's easy enough. Restore the full with no recovery and each day copy the diff over and restore that with norecovery.
What do you want to do with the second server?...
November 12, 2008 at 12:36 am
krayknot (11/12/2008)
yesstore the pricing in xml and at the tiime of requirement, call the xml data in table variable (if the size is upto medium) and use temp table temprarily.
How...
November 12, 2008 at 12:35 am
Chirag (11/11/2008)
You will have to re-create all your jobs, maintenance plans etc.
And DTS packages and SSIS packages. You've also lost the backup history.
Now, go and set up a backup schedule...
November 12, 2008 at 12:33 am
My guess is that you're truncating the tran log at some point. Look through the jobs and see if you have a BACKUP LOG ... WITH TRUNCATE_ONLY or BACKUP LOG...
November 12, 2008 at 12:32 am
They're produced by a crash of the DB engine or an illegal operation by one of the processes. The best thing to do if you're getting frequent stack dumps is...
November 12, 2008 at 12:30 am
sairams (11/11/2008)
Dear kshitij,Thanks 4 your reply...
Encrypting the confidential values means i need to do a mass work on the application..Is there any other better option
No better option. Encryption...
November 12, 2008 at 12:28 am
Have you created the endpoints? Can you connect from the principal to the mirror (try ping) and vis versa?
November 12, 2008 at 12:19 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic600933-146-1.aspx
November 11, 2008 at 2:37 pm
Viewing 15 posts - 43,201 through 43,215 (of 49,566 total)