Viewing 15 posts - 4,036 through 4,050 (of 9,241 total)
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
khott (7/3/2013)
With always on, have one active node for production applications, one node for reporting with different...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2013 at 4:33 am
davidwarner (7/2/2013)
The DNS names of the servers will change.
Are you referring to the node computernames?
What do you mean DNS names will change?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2013 at 1:06 am
as long as you have access to a DNS server and a domain controller it shouldn't make any difference to you.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2013 at 8:33 am
Viewing 15 posts - 4,036 through 4,050 (of 9,241 total)