Viewing 15 posts - 7,021 through 7,035 (of 9,244 total)
I concur, Michelle's script is awesome.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:18 am
i haven't mentioned Exchange server, i pointed the OP to Books Online to gain information on how to enable and configure Database Mail on a SQL Server instance 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:16 am
don't give out SA privileges 😀
I ask them to explain why they need SA, when they can't give a valid reason i use that as my push back 😉
It's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:10 am
check Books Online for configuring a database mail profile 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 4:56 am
TST1 (7/4/2011)
I'm looking for a script that will tell me who did the restore and how long it took. I've got a script which gives me file details but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 4:51 am
KKK17 (6/30/2011)
Thanks a lot for the replies..
I have found a script which creates logins on the secondary server using linked server. This script runs on secondary server and can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 4:40 am
easier for pure reporting is log shipping. Easy to setup and maintain but read only (which is all your reports should need)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 4:29 am
you might also want to configure a mail profile for database mail so that the stored procedure SP_NOTIFY_OPERATOR doesn't fail too! 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 4:14 am
Coolroof (7/4/2011)
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 4:08 am
64kb and 256kb are both optimal recommended stripe sizes for SQL server storage drives. Personally, if using Windows 2008 you do not want to accept the default of 1MB but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 12:11 am
Are both machines joined to the same domain or are they stand alone servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2011 at 11:54 pm
It's surprisingly easy to gain access to a SQL server instance. In my previous post to this thread there are details of how to accomplish this. Also some one has...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2011 at 2:47 am
hi
my guide covers sql server 2008 on either a windows 2008 or a windows 2003 cluster. Which OS are you using? PM your email address and i'll send the requested...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2011 at 4:02 am
KKK17 (6/26/2011)
but my point is to a specific database.I dont want to transfer all the logins to the secondary server.
Something like this would be easier for you, just be sure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2011 at 10:08 am
Greg Roberts-134214 (6/24/2011)
Perry Whittle (6/23/2011)
IIRC MIcrosoft do not support or recommend teamed NICs for iSCSI,
You should be using the Multi Path IO component...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2011 at 3:01 am
Viewing 15 posts - 7,021 through 7,035 (of 9,244 total)