Viewing 15 posts - 16 through 30 (of 110 total)
Perry Whittle (11/28/2012)
raotor (11/28/2012)
2. Why ever destroy the existing chain by performing a second full backup other than for purely space or management reasons?
Full backups DO reset the Differential Base...
November 28, 2012 at 11:58 am
anthony.green (11/14/2012)
Nothing more? Nothing above or below that line?
As far as I can tell, no.
There are multiple errors appearing within the SQL Server section of the error log viewer....
November 14, 2012 at 5:47 am
anthony.green (11/14/2012)
What does the SQL error log say?
SQL Server Log:
Date14/11/2012 10:15:28
LogSQL Server (Current - 14/11/2012 10:15:00)
Sourcespid57
Message
The file "FullDB" failed to initialize correctly. Examine the error logs for more details.
November 14, 2012 at 3:58 am
Perry Whittle (11/14/2012)
can you post details of the exact error you receive?
Sure,
here's the entire output from the restore of the 4th log backup:
10 percent processed.
20 percent processed.
30 percent processed.
40 percent...
November 14, 2012 at 3:18 am
Thanks for your reply.
I've now solved the problem, but when I tried your suggestion of using the TRUNCATE_ONLY option on the log backup I received the following error:
Msg 155, Level...
November 8, 2012 at 4:11 am
I ran the two commands you suggested. However, the second one told me that "LOG BACKUP" was needed. So, I performed another log backup and then did a SHRINKFILE on...
November 8, 2012 at 4:06 am
H4K (9/11/2012)
Right click on any column header and select Insert Column > Left / Right.
OK, now I feel stupid! 🙂
Many thanks for your help.
September 11, 2012 at 7:32 am
Robin Sasson (9/5/2012)
September 5, 2012 at 6:57 am
GilaMonster (8/28/2012)
There is one. See the blog post I referenced.
Hello Gail,
Just one thing I've noticed that I think is important to clarify. When using the SET XACT_ABOIRT ON it should...
August 28, 2012 at 7:07 am
GilaMonster (8/28/2012)
There is one. See the blog post I referenced.
Just read it and it's most helpful and just what I was looking for. Thanks.
August 28, 2012 at 6:08 am
laurie-789651 (8/28/2012)
Thinking about it, you can set up automatic transactions, although I've never done it:
Thanks very much for the link.
I will take a look at it. Does seem to me...
August 28, 2012 at 5:09 am
sturner (8/17/2012)
He means use raiserror() in the catch block.
Ahhhh, thanks, I'll give that a go. 🙂
August 17, 2012 at 8:29 am
Lynn Pettis (8/17/2012)
Reraise the error CATCH block. About the only way I can think of handling it.
Sorry, "Reraise" ?
August 17, 2012 at 8:16 am
I had added a new NOT NULL column into a table which was being inserted into via a stored procedure in step 3 of the job. Since I had forgotten...
August 17, 2012 at 8:04 am
Thanks so much for your time helping me with all this.
I will take a look at the link you kindly provided.
If I may ask, seeing as you're using mirroring between...
August 9, 2012 at 6:35 am
Viewing 15 posts - 16 through 30 (of 110 total)