Viewing 15 posts - 346 through 360 (of 756 total)
Brown,
I'm glad you solved the problem, but at the same time I find it very dangerous that other people are able to restart your SQL Server.
July 28, 2011 at 1:33 pm
Ninja's_RGR'us (7/28/2011)
I was reffering to putting model into norecovery and THEN restarting the server or making a new DB. 😀
Ok, I misundersood! 😀
July 28, 2011 at 9:35 am
brown-415622 (7/28/2011)
If your curious the results of the query were
"RESTORE DATABASE successfully processed 0 pages in 4.004 seconds...
July 28, 2011 at 9:34 am
Ninja's_RGR'us (7/28/2011)
brown-415622 (7/28/2011)
Thanks I will try this, is it ok to try this during production hours?
I have never seen / tested that scenario and I don't intend to try it...
July 28, 2011 at 9:02 am
brown-415622 (7/28/2011)
Thanks I will try this, is it ok to try this during production hours?
If you are referring to the restore script from Suresh, the answer is yes, you...
July 28, 2011 at 8:59 am
Ninja's_RGR'us (7/28/2011)
Ignacio A. Salom Rangel (7/28/2011)
brown-415622 (7/28/2011)
It was a fresh install. Just noticed that the database was in stuck in restore state a day or two later.
So, you did not...
July 28, 2011 at 8:57 am
brown-415622 (7/28/2011)
Thanks I will try this, is it ok to try this during production hours?
Are you referring to the restore script for the model database?
July 28, 2011 at 8:50 am
brown-415622 (7/28/2011)
It was a fresh install. Just noticed that the database was in stuck in restore state a day or two later.
So, you did not restore the model database. hen...
July 28, 2011 at 8:47 am
laddu4700 (7/27/2011)
What are the different ways to provide the reports to end users.
Currently we are running sql scripts and providing report s in excel.
But client is asking , provide reports...
July 28, 2011 at 8:44 am
Koen Verbeeck (7/28/2011)
Ignacio A. Salom Rangel (7/28/2011)
Koen, could you please add the script for creating the linked server with ODBC. Thanks in advance!
Here you go:
/****** Object: LinkedServer [LINKED_ODBC_VILLANEXT] ...
July 28, 2011 at 7:37 am
stephen.lappe (7/28/2011)
I have tried the following...
July 28, 2011 at 6:56 am
Koen, could you please add the script for creating the linked server with ODBC. Thanks in advance!
July 28, 2011 at 6:50 am
chandan_jha18 (7/28/2011)
As you stated that you are on 2008 R2, you can try compressing the backup and see how much size it comes to. Also, i mentioned in my previous...
July 28, 2011 at 6:36 am
Brandie Tarvin (7/28/2011)
forsqlserver (7/28/2011)
2) He didn't say backup compression wasn't used in 2008. He said 2008 Enterprise version used it. Standard doesn't have compression capabilities in 2008.
Thanks for clarifying!
July 28, 2011 at 6:34 am
chandan_jha18 (7/28/2011)
I was just mentioning that 2008 R standard edition supports backup compression.
And no my Lord. That comment was not directed to you. I am sure that you have...
July 28, 2011 at 6:33 am
Viewing 15 posts - 346 through 360 (of 756 total)