Viewing 15 posts - 7,021 through 7,035 (of 9,241 total)
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
The main issue you'll face is around windows accounts. As I already mentioned the stored procedure will script certain windows accounts that you don't want to apply to the target....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2011 at 1:06 am
How large is the database that fails to backup?
How much free space is available on the network location?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 24, 2011 at 4:21 pm
In my experience with NetApp filers all disks are usually part of the same aggregate with volumes and LUNs carved out of the aggregate and surprisingly enough this is NetApps...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 24, 2011 at 4:16 pm
Viewing 15 posts - 7,021 through 7,035 (of 9,241 total)