Viewing 15 posts - 4,036 through 4,050 (of 9,244 total)
mac_live (7/15/2013)
I am really hard to finding how many databases are under logshipping in a given server. also that script need to get databases (means that script support any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2013 at 8:59 am
$w@t (7/15/2013)
thank you for reply...I am using sql server 2008 R2...
Given this, what is your allowable latency for restoring the logs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2013 at 8:21 am
msimone (7/15/2013)
The average bytes/read is between 64k and 128k and the average bytes/write is between 32k and 64k.
What is the best, Raid 10 2+2 with stripe size 128k and cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2013 at 8:19 am
gaddamshiva (7/13/2013)
Hi...How to take backup of Single table and how to restore? is there any query like database backup?
shivakumar...
if you want to just copy the data...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2013 at 8:16 am
The cluster cannot see any shared disks
have you presented the storage to all nodes that will participate in the failover cluster instance?
have you added the new storage to the cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2013 at 8:12 am
This link explains further
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2013 at 8:12 am
stakes (7/11/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2013 at 8:07 am
The guide uses Windows 2008 virtual machines running under VMWare Server 2.0 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2013 at 7:33 am
ananda.murugesan (7/10/2013)
SQL Service account running under windows local users.. But domain users are added into SQL logins for connection between database and application...so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2013 at 7:31 am
See my 3 part guide at the following links
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2013 at 3:45 am
If you're using Windows 2008, ensure you get the latest version of SETSPN.EXE which can identify any duplicates which won't usually be visible via ADSIEDIT or ealier versions of SETSPN.EXE.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2013 at 3:34 am
MuraliKrishnan1980 (7/9/2013)
I got the issue resolved by deleting the User from the Database and mapping the login to the DB after that..
for future reference there's no need to delete the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2013 at 5:13 am
jasona.work (7/8/2013)
seen several postings here from people trying to do maintenance in single-user and getting beat to the connection by an application or other user..
The trick is to set the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2013 at 11:09 pm
jasona.work (7/8/2013)
1. Can I backup a DB that is in an offline state? I'm inclined to think no.
No, you cannot backup an offline database, however you can copy...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2013 at 8:53 am
if you run the remove node action in the sql server setup the node is removed from the specified clustered instance of sql server, it is not removed from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2013 at 6:49 am
Viewing 15 posts - 4,036 through 4,050 (of 9,244 total)