Viewing 15 posts - 6,616 through 6,630 (of 9,244 total)
sqlbuddy123 (9/13/2011)
Right, Mirrored DB is not accessible at all times.Thank You,
Best Regards,
SQLBuddy
Unless you're using Enterprise edition...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2011 at 3:42 am
kapfundestanley (9/13/2011)
So you mean on top of the daily back-ups i am taking, i need to take Daily transaction logs as well?
Yes, in full recovery model you need to take...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2011 at 5:29 am
Log shipping stored procedures are detailed here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2011 at 1:47 am
The paths do not need to be the same. Can you provide more details on the setup?
Is this server part of a windows domain or a workgroup?
What user account do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2011 at 12:09 am
File share witness for Maj Node Sets is a little known trick in Windows 2003 but works well and is a standard quorum option in Windows 2008.
The DTC data must...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2011 at 11:17 am
bsegermeister (9/12/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2011 at 10:50 am
sqlcool (9/9/2011)
Added the login (company\developers) as dbreader & dbowner
Ensure you make this change at the primary server and simply allow log shipping to take it's course. Also add the server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2011 at 2:14 pm
After the upgrade also run dbcc updateusage on all DBS.
Valid point on replication but it was never mentioned.
Paul given the time it takes to backup, copy, restore especially for large...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2011 at 8:13 am
bsegermeister (9/8/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2011 at 2:01 am
bsegermeister (9/8/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2011 at 1:59 am
sqlguy-736318 (9/8/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2011 at 1:49 am
sqlguy-736318 (9/8/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2011 at 1:45 am
Does the remote server have a firewall running?
Go into SQL server configuration manager on the remote server and check the protocols enabled.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2011 at 5:49 pm
Sounds good to me
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2011 at 4:33 pm
In the last 7 years i've used either Litespeed or SQLBackup and they're both good, although SQLBackup would be my preference.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2011 at 1:34 pm
Viewing 15 posts - 6,616 through 6,630 (of 9,244 total)