Viewing 15 posts - 1 through 15 (of 26 total)
Thanks Jason for the reply.
My database is in Full Recovery mode and the spaces allocated to both the database file and the transaction log file is set to 406 and...
September 17, 2004 at 5:48 pm
Thanks for all the replies to my question. My SQL Server is finally up and running, and so does my log shipping...I am a happy person once again... Well it's...
September 9, 2004 at 3:35 pm
Thanx steve for your response to my question. I appreciate that...however now the problem is my msdb database is showing suspected...and I cannot select the properties...is there a way I...
September 8, 2004 at 11:46 am
Thanx Derrick,
The reason why we don't have SP3a right now is we are running a financial application called SOLOMON which is from Microsoft. But the problem is if we upgrade...
July 5, 2004 at 3:42 pm
Thanx for the replies.
Yes, we have the service pack installed on both our production server and the other machine. Due to some reason we are not using the SP3 but...
July 5, 2004 at 10:16 am
Thanx Nicholas,
It worked...one more question.....is there a way that I can use the EXEC statement to return a value in a variable...
e.g..
declare @mycount int
set @mycount=exec('select count(*) from HeaderTransLog')
Thanx
Muneeb.
June 16, 2004 at 11:27 am
Thanx Pat for your reply, but I need to use the variable in the FROM clause of the SELECT statement.
Is there a way I can use the variable in the...
June 16, 2004 at 11:17 am
Hi all,
Thanx to everyone whoever contributed to answer my question...these suggestion and guildlines helped me a lot..however, I found out what was causing the problem...its was a little and silly...
June 11, 2004 at 10:25 am
Q: Exactly how my backups were done?
Ans: It's a full backup executed by a job agent every night at 10:30pm on a network shared drive before copying to a backup...
June 9, 2004 at 2:19 pm
Thanx for replying to my post Nicholas..
My logshipping is 24x7 every 10 mins of interval...and it's working fine...the only issue is the backup right now....and the log files that I...
June 9, 2004 at 2:12 pm
Thanx for all the suggestions I got in this forum. I have changed the recovery model to Full and now I'm getting the logs as well...right now I'm monitoring my...
June 2, 2004 at 11:07 am
Thanx SQLBill and Nicholas Cain for your thoughts. I appreciated. I find this forum really useful and helps me a lot if guys like you keep an eye on this...
June 1, 2004 at 2:06 pm
Thanx Bert De Haes. This is what I was actually looking for. One more question please. It's kind of silly but since I'm new and would like to find out...
March 23, 2004 at 10:56 am
Thanx SQLBill.
So, does this means that if I take the differential back then I don't have to restore all the backup set in the Transaction file one by one manually....
March 19, 2004 at 12:35 pm
My mistake, sorry for that.
Muneeb.
March 19, 2004 at 12:23 pm
Viewing 15 posts - 1 through 15 (of 26 total)